Transpose a List to a Metrix

[PR]

Can anyone help me with a issue I have in trying to get a list of people and
what applications their use from a list into a metrix...
below is the list of people with the application their use...

Mr A Excel
Mr A Word
Mr A Access
Mr A PowerPoint
Mr A Visio
Miss B Excel
Miss B Word
Miss B Access
Mrs C Excel
Mrs C PowerPoint
Master D Project

what I want to do is turn it into this...

Excel Word Access PowerPoint
Visio Project
Mr A 1 1 1 1
1
Miss B 1 1 1
Mrs C 1 1
Master D
1

Regards,
Paul

 

[Dave Peterson]

This sounds like a good project to learn about pivottables.

If your data doesn't have headers, add them to row 1.

Then you could select your data (A1:Bxxx) and use:
Data|Pivottable and pivotchart report (in xl2003 menus)

Then follow that wizard until you get to a step with a Layout button on it.

Hit that Layout button.

Drag the header for the name to the row field.
Drag the header for the application to the column field.
Drag the header for the application (again!) to the data field.

And finish up the wizard.

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[PR]

Dave,
that is very good... easy...

many thanks

This sounds like a good project to learn about pivottables.

If your data doesn't have headers, add them to row 1.

Then you could select your data (A1:Bxxx) and use:
Data|Pivottable and pivotchart report (in xl2003 menus)

Then follow that wizard until you get to a step with a Layout button on
it.

Hit that Layout button.

Drag the header for the name to the row field.
Drag the header for the application to the column field.
Drag the header for the application (again!) to the data field.

And finish up the wizard.

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx