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,
Kevin B - 28 May 2008 16:09 GMT
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...

Signature
Kevin Backmann
> Hi all!
> I'm in trouble! I have a list of data I have to transform in a table and I
[quoted text clipped - 23 lines]
>
> Thank you,