Convert list to table
 

Hi all!
I'm in trouble! I have a list of data I have to transform in a table and I
don't know how to do it.
I'll be extra clear:
I have an excel table formatted this way:

NAME - DATE - VALUE
TOD - JAN-07 - 31
JIM - JAN-07 - 32
SUE - JAN-07 - 14
TOD - FEB-07 - 33
JIM - FEB-07 - 22
SUE - FEB-07 - 16

And I need to transform it like this:

JAN-07 - FEB-07
TOD 31 33
JIM 32 22
SUE 14 16

Hope it is clear enough.

Any idea? I can't do it by hand because we are talking of about 7000 rows,
so I need to automate it somehow!

Thank you,

Convert list to table
 

You can accomplish that with a pivot table, which will leave your original
list intact

The Name field is a pivot table row field
The date field is a pivot table column field
The value field is a pivot table data field

Hope this helps...
--
Kevin Backmann


"Phelit" wrote:

Hi all!
I'm in trouble! I have a list of data I have to transform in a table and I
don't know how to do it.
I'll be extra clear:
I have an excel table formatted this way:

NAME - DATE - VALUE
TOD - JAN-07 - 31
JIM - JAN-07 - 32
SUE - JAN-07 - 14
TOD - FEB-07 - 33
JIM - FEB-07 - 22
SUE - FEB-07 - 16

And I need to transform it like this:

JAN-07 - FEB-07
TOD 31 33
JIM 32 22
SUE 14 16

Hope it is clear enough.

Any idea? I can't do it by hand because we are talking of about 7000 rows,
so I need to automate it somehow!

Thank you,