Hi all.
I am a relative noob when it comes to Excel, so I hope there is someone who can help me out with a probably trivial problem.
Thing is, I am logging data to a CSV file. All the data is added sequentally to the file.
If I open it with Excel it looks like this:
I would like it much more if I could convert it to something like this:
But how can I achive that ?
With some clever sorting or a macro ?
Edit: it looked awful at first. Its not so easy to paste directly from Excel.
I am a relative noob when it comes to Excel, so I hope there is someone who can help me out with a probably trivial problem.
Thing is, I am logging 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 ?
Edit: it looked awful at first. Its not so easy to paste directly from Excel.
Last edited: