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?
|1001||Client 1||Y||No||Y||First Name|
|1001||Client 1||Y||No||Y||Last Name|
|1001||Client 1||Y||No||Y||Date of Birth|
I would like for the following to display:
|Date of Birth|
Including the values for the rest of the rows. Can this be done?
Do not upload personal identifiable data as it is publicly visible; it will have to be some dummy data.