Hi all.
I am a noob when it comes to Excel, so I hope there is some of you gurus who can help me out with a probably trivial problem.
Thing is, I have a program that automatically logs data to a CSV file. All the data is added sequentally to the file.
If I open it with Excel it looks like this:
VarName TimeString VarValue
Test_tag_00 20-10-2005 13:41 1
Test_tag_01 20-10-2005 13:41 2
Test_tag_02 20-10-2005 13:41 3
Test_tag_03 20-10-2005 13:41 4
Test_tag_00 20-10-2005 13:48 1
Test_tag_01 20-10-2005 13:48 2
Test_tag_02 20-10-2005 13:48 3
Test_tag_03 20-10-2005 13:48 4
I would like it much more if I could convert it to something like this:
TimeString Test_tag_00 Test_tag_01 Test_tag_02 Test_tag_03
20-10-2005 13:41 1 2 3 4
20-10-2005 13:48 1 2 3 4
But how can I achive that ?
With some clever sorting or a macro ?
Bookmarks