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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

But how can I achive that ?
With some clever sorting or a macro ?

[Adrian M]

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.

"JesperMP" wrote:

>
> 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:
>
>
> 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 4
> --------------------
>
>
>
> I would like it much more if I could convert it to something like
> this:
>
>
> Code:
> --------------------
> 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 ?
>
>
> --
> JesperMP
> ------------------------------------------------------------------------
> JesperMP's Profile: http://www.excelforum.com/member.php...o&userid=28237
> View this thread: http://www.excelforum.com/showthread...hreadid=477870
>
>

[Cathy]

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.



"JesperMP" wrote:

>
> 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:
>
>
> 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 4
> --------------------
>
>
>
> I would like it much more if I could convert it to something like
> this:
>
>
> Code:
> --------------------
> 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 ?
>
>
> --
> JesperMP
> ------------------------------------------------------------------------
> JesperMP's Profile: http://www.excelforum.com/member.php...o&userid=28237
> View this thread: http://www.excelforum.com/showthread...hreadid=477870
>
>

[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 to rows and vice-versa. The data has to be sorted in several columns with 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 I wanted.

Thanks !!