asked on Grouping or Using Pivot tables
I have an excel sheet with almost 2000 rows which I like to group. I tried with a pivot table, but I can only collapse one column. Any ideas?
| CLIENTID | NAME | Config1 | Config2 | Config3 | TITLE |
| 1001 | Client 1 | Y | No | Y | First Name |
| 1001 | Client 1 | Y | No | Y | Last Name |
| 1001 | Client 1 | Y | No | Y | Gender |
| 1001 | Client 1 | Y | No | Y | Date of Birth |
I would like for the following to display:
| Client 1 |
| Date of Birth |
| First Name |
| Gender |
| Last Name |
Including the values for the rest of the rows. Can this be done?
Microsoft ExcelMicrosoft Office
Last Comment
Rob Henson
ASKER
The first table is the sample data. So as you can see, the first 5 columns contain the exact same rows for Client 1, except the last column. I would like for the rows in the last column to be collapsible somehow so the rows containing basic information are not repeated.
Still unclear what you want. As Rob suggests, please post a sample file with 4-5 clients' worth of fake data, and the results you would expect given those inputs.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Do not upload personal identifiable data as it is publicly visible; it will have to be some dummy data.