Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to rearrange data
The only problem is that what is inside the table are names, not
numbers. I do not think names can be put inside a pivot table. Is there a solution? Michel how to rearrange data From: Alex J Date Posted: 9/18/2004 4:37:00 PM Michel, Your best bet would be a Pivot table AlexJ "Michel Rousseau" wrote in message ... How can one rearrange the following yearly data into a summary table form with years going across? It is in an excel worksheet example: names of mayors municipality year name xxx 1901 zzz etc. etc. etc. I would like the new table to have the municipality running down the left side, the years running across and the names of the mayors inside the table. Thank you. Michel *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rearrange data... | Charts and Charting in Excel | |||
rearrange data | Excel Discussion (Misc queries) | |||
rearrange data by day | Excel Discussion (Misc queries) | |||
how to rearrange data | Excel Programming | |||
transpose/rearrange data | Excel Programming |