#1
|
|||
|
|||
Flip Value Date wise Vertically
Hi Experts,
See attached file. I need to tabulate the time vertically with dates as highlighted in attached. Data will add to left hand side horizontal table and I need to automatically tabulate these details to right hand side highlighted table. Which formula I've to use for this? Note that, the dates and times will add at left. Can you please advise. Thanks in advance for your help. Regards, Sunil Thomas |
#2
|
|||
|
|||
I defined tables as Tables - so all formulas will adjust automatically whenever new data is added into source table.
In both original and added Tables are some helper columns I colored differently. You can hide those to avoid confusion, as user don't need to see them at all. To apply automation, I defined some Named Ranges. Currently TimeTable has 99 pre-prepared rows. It will be enough for INT(99/6) = 17 dates with current number of times in source table. When this limit will be overrun, you simply expand TimeTable for some number of rows. You can set the autofilter for Time column in TimeTable to 'not empty'. This filters out both empty rows at bottom of table, and rows where time field in source for this date was empty. |
#3
|
|||
|
|||
Quote:
|
Tags |
flip data date wise, flip value vertically |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula For Sorting In Order Date Wise | suniltko | Excel | 5 | 05-15-2018 09:18 PM |
Auto-filter horizontally column wise on basis of date | shoaib1989 | Excel | 0 | 02-18-2016 11:16 PM |
How to fetch data from one sheet to another with complete details and date wise as well | harisjawed86 | Excel Programming | 1 | 08-05-2014 09:10 PM |
world flip pages | AfterLife6 | Word | 1 | 04-27-2012 04:43 PM |
doc to flip book | gspot | Word | 0 | 06-01-2009 03:51 AM |