Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Convert list to table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Phelit - 28 May 2008 15:56 GMT
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,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.