Use Pivot Table, refer the attached file for details.
Place the Cursor In A5 cell and do right Click>>Expand/Collapse>>Try Expand Entire Field Or Collapse Entire Field. Click the Plus Sign individually to see the individual data when the field is in collapsed mode.
Edit: Oopss I have not pressed F5 to refresh the page. Just worked with excel file based on first post![]()
Bookmarks