Microsoft Office Forums Flip Value Date wise Vertically

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2019, 10:26 PM
suniltko suniltko is offline Flip Value Date wise Vertically Windows 7 64bit Flip Value Date wise Vertically Office 2010 64bit
Novice
Flip Value Date wise Vertically
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 8
suniltko is on a distinguished road
Flip Value Date wise Vertically
Default 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
Attached Files
File Type: xlsx Flip Value Date wise.xlsx (13.3 KB, 3 views)
Reply With Quote
  #2  
Old 05-28-2019, 12:26 AM
ArviLaanemets ArviLaanemets is offline Flip Value Date wise Vertically Windows 8 Flip Value Date wise Vertically Office 2016
Expert
 
Join Date: May 2017
Posts: 448
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

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.
Attached Files
File Type: xlsx Flip.xlsx (22.1 KB, 4 views)
Reply With Quote
  #3  
Old 05-28-2019, 12:39 AM
suniltko suniltko is offline Flip Value Date wise Vertically Windows 7 64bit Flip Value Date wise Vertically Office 2010
Novice
Flip Value Date wise Vertically
 
Join Date: Mar 2017
Location: Bangalore, India
Posts: 8
suniltko is on a distinguished road
Flip Value Date wise Vertically
Default

Quote:
Originally Posted by ArviLaanemets View Post
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.
Thank You for this quick response and our time. It is working fine. Thanks again.
Reply With Quote
Reply

Tags
flip data date wise, flip value vertically

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Flip Value Date wise Vertically 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


All times are GMT -7. The time now is 10:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft