Dear readers,
I have a problem with aligning data from 2 different columns with one.. and have tried various things but to no success.
I am trying to align data at 5min time intervals on a row by row basis, so for example, the time interval 20:05 will have the values 5 and 10 on the same row rather than different ones like below. Columns B and D do not always have values for each row of Column A and C (they are blank as no data was obtained for that specific time interval):
Column A Column B Column C Column D
20:05 5 20:00
20:45 7 20:05 10
20:55 20:40 8
21:05 11 20:45 5
21:10 18 21:05 4
21:15 2 21:10 15
21:20 4 21:15
21:35 21:25 9
22:10 11 21:30 8
And so on... etc.
I want to get the following arrangment from the above data:
Column A Column B Column C
20:00 5
20:05 7 10
20:10
20:15 2
20:20 4
20:25
20:30 11
20:35
20:40 8
20:45 5
20:50
20:55
21:00
21:05 11 4
21:10 18 15
21:15
21:20
21:25 9
21:30 8
And so on... etc.
Is there any way of doing this on Excel? I have hundreds of lines which are not arranged, hence this would help me big time if there is.
Kind regards to all who reply.
Shimu
Bookmarks