![]() |
#1
|
|||
|
|||
![]()
I have a meter interval data with time values in other columns and date in rows like below
![]() KYUSHU0911000001993100000000 6:30:00 AM 7:00:00 AM 7:30:00 AM 8:00:00 AM 8:30:00 AM 9:00:00 AM 9:30:00 AM 10:00:00 AM 10:30:00 AM 31/08/2017 0 4534.412955 4050.607287 3811.740891 3838.05668 3801.619433 3649.797571 3797.57085 4062.753036 1/09/2017 4572.874494 4552.631579 4850.202429 4706.477733 5170.040486 5414.979757 5052.631579 5018.218623 4997.975709 4/09/2017 5263.157895 5208.502024 5491.902834 5404.8583 5425.101215 5291.497976 5340.080972 5186.234818 5439.271255 5/09/2017 5390.688259 5054.65587 5159.919028 5690.283401 5538.461538 5550.607287 5451.417004 5354.251012 5595.1417 I want all the times values to be associated with every date and then date in repeated for evert time values like below 28/08/2017 0:00 28/08/2017 0:30 28/08/2017 1:00 28/08/2017 1:30 28/08/2017 2:00 28/08/2017 2:30 28/08/2017 3:00 28/08/2017 3:30 28/08/2017 4:00 28/08/2017 4:30 28/08/2017 5:00 28/08/2017 5:30 28/08/2017 6:00 28/08/2017 6:30 28/08/2017 7:00 28/08/2017 7:30 28/08/2017 8:00 28/08/2017 8:30 28/08/2017 9:00 28/08/2017 9:30 28/08/2017 10:00 I have tried it with index match but I am not getting the required result and even tried pasting it with transpose and add value |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame | jay_excel | Excel | 0 | 07-29-2017 11:04 PM |
OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
Multiple found values from five sheets, multiple returned values in sheet six? | irisha | Excel Programming | 26 | 09-30-2016 01:20 AM |
Display multiple values as new values based on selection from template. | MvdB | Excel | 2 | 09-29-2015 08:51 PM |
![]() |
pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |