How to automatically rearrange data on a worksheet.

[JesperMP]

Hi all.
I am a noob when it comes to Excel, so I hope there is some of yo
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:


Code
-------------------
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
-------------------



I would like it much more if I could convert it to something lik
this:


Code

 

[Guest]

You may want to try and use a pivot table. You can see how to do it in the
middle of the page http://www.auditexcel.co.za/othertools.html . Once it is
in the pivot table format you can pretty much sort in whatever way you like.
Hope this helps.

 

[Guest]

You can also achieve the result you are looking for using a function called
'Transpose'. Look in your Excel help area for instructions on how to use
this function.

 

[Random Poster]

Take a look at Excel's pivot table feature (under the Data menu).


-RP

 

[JesperMP]

Thanks for the responses.

I dont think that TRANSPOSE will do the job. It only flips columns t
rows and vice-versa. The data has to be sorted in several columns wit
the data from one VarName in one column.

I will look into the pivot tables

 

[JesperMP]

Adrian,

that link to how to work with pivot tables was awesome !

After going throught it I could arrange and graph my data just like
wanted.

Thanks !