View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phelit Phelit is offline
external usenet poster
 
Posts: 1
Default 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,