Paul Gardner
asked on
Convert Pivot Table Data
I have a worksheet that contains the columns: Person ID code, Name, Location. Each person has at least one location, but many have multiple locations. People with multiple locations have their ID code & name duplicated in subsequent rows, The different location is then stored. For example:
ID Code Name Location
12345 Bloggs, Joe London
12345 Bloggs, Joe Manchester
67890 Smith, Jim Manchester
67890 Smith, Jim Southampton
What I want to do is convert the layout so it is :
ID Code Name Location1 Location2 Location3
12345 Bloggs, Joe London Manchester
67890 Smith, Jim Manchester Southampton
I have created a pivot table which has grouped the people with their locations easily enough. But what I cannot figure out next is how to export the pivot table so that each element in the pivot table report occupies one row in a new worksheet.
ID Code Name Location
12345 Bloggs, Joe London
12345 Bloggs, Joe Manchester
67890 Smith, Jim Manchester
67890 Smith, Jim Southampton
What I want to do is convert the layout so it is :
ID Code Name Location1 Location2 Location3
12345 Bloggs, Joe London Manchester
67890 Smith, Jim Manchester Southampton
I have created a pivot table which has grouped the people with their locations easily enough. But what I cannot figure out next is how to export the pivot table so that each element in the pivot table report occupies one row in a new worksheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER