how to rearrange data

  • Thread starter Thread starter Michel Rousseau
  • Start date Start date
M

Michel Rousseau

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to rearrange data 4
REARRANGE STRINGS IN ARRAY !!!! 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Rearrange data into Columns in same row 6
macro for rearranging data 7
A code to import other xls data into one xls file 3
Rearrange/Transpose Data 1
Extract Date, and summarize data request 1

Back
Top