Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the following Pivot Table from an excel sheet. Types of Machines: Desktop, Laptop, Server Numbers represent count of each type for each person.

Name         Desktop     Laptop     Server
John               3         1            
Dave                         5           1
Miles              1                     2

1) I want each one record per type ( Desktop, Laptop, Server) per Name. Is there any way to extract that data in Excel 2007?

2) I want to extract data for Desktop and Laptop alone. How do I select those data alone?

share|improve this question

migrated from stackoverflow.com Oct 7 '11 at 17:27

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Ad 1)

I'm not sure what you mean by "one record per type". Do you want to have a table like this:

John - Desktop - 3
John - Laptop - 1
Dave - Laptop - 5
Miles - Desktop - 1
Miles - Server - 2

Depending on the data source my guess is that the original data already has this exact form, you just have to delete a couple of columns of extra data that you don't want to see there.

Ad 2)

Directly above the column-header "Desktop" should be a dropdown control. Once you click that you should be able to de-select "Server" (or only select "Desktop" and "Laptop" again depending on the data and the specific layout of the table).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.