LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert a formatted table back to a list marcopolo Excel Discussion (Misc queries) 0 March 20th 08 03:08 PM
How to convert a table to list? ferdi Excel Worksheet Functions 1 March 17th 07 03:14 AM
How to convert existing Excel List into a table in Access? anna New Users to Excel 2 June 18th 06 11:57 PM
Convert Pivot Table to Normal Data table ashish128 Excel Discussion (Misc queries) 2 May 2nd 06 09:34 AM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 06:45 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"