View Single Post
 
Old 09-25-2017, 06:07 AM
sarahafeez sarahafeez is offline Windows 10 Office 2016
Novice
 
Join Date: Sep 2017
Posts: 1
sarahafeez is on a distinguished road
Default append multiple time values to date in one column

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
Reply With Quote