hi guys,
here i got a question as below. can anybody kindly help on this? thanks in adv.
Original layout:
ColumnA ColumnB ColumnC
2006-6-28 9:00 24465
2006-6-28 12:00 25609
2006-6-28 15:00 27295
2006-6-29 9:00 27309
2006-6-29 12:00 27312
2006-6-29 15:00 24465
2006-6-30 9:00 27295
2006-6-30 12:00 27302
2006-6-30 15:00 27309
......
I wanna re-layout it listed in this format:
NewColumnA NewColumnB(9:00) NewColumnC(12:00) NewColumnD(15:00)
2006-6-28 24465(ColumnC1) 25609(ColumnC2) 27295(ColumnC3)
2006-6-29 27309(ColumnC4) 27312(ColumnC5) 24465(ColumnC6)
2006-6-30 27295(ColumnC7) 27302(ColumnC8) 27309(ColumnC9)
......

if there is any method or function to do this automatically?