joining multiple time values with single date in one column

Status
Not open for further replies.
S

sarahafeez

New member
Joined
Sep 25, 2017
Messages
2
Reaction score
0
Points
0
I have the a meter data with 30 min showing time in different columns and dates in rows like:
KYUSHU09110000019931000000006:30:00 AM7:00:00 AM7:30:00 AM8:00:00 AM8:30:00 AM9:00:00 AM9:30:00 AM10:00:00 AM10:30:00 AM
31/08/201704534.4134050.60733811.74093838.05673801.61943649.79763797.570854062.75304
1/09/20174572.87454552.63164850.20244706.47775170.04055414.97985052.63165018.218624997.97571
4/09/20175263.15795208.5025491.90285404.85835425.10125291.4985340.0815186.234825439.27126
5/09/20175390.68835054.65595159.9195690.28345538.46155550.60735451.4175354.251015595.1417


s there any way I can associate the every time values with every date in rows like this like below.I have been trying to use index match but I am unable to figure out what can work, tried different transpose and added the values as well, didn't work

date
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
 
Yes, this is possible. Several ways. Supply a file so that we can show you.
 
Duplicate thread which has been both addressed by a Moderator for crossposting and answered with a suggestion.

Please correct that thread and then continue over there.
 
Status
Not open for further replies.
Back
Top