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?