Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert a formatted table back to a list | Excel Discussion (Misc queries) | |||
How to convert a table to list? | Excel Worksheet Functions | |||
How to convert existing Excel List into a table in Access? | New Users to Excel | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
convert excel list to pivot table | Excel Discussion (Misc queries) |