Dear Experts,
I need help with writing a VBA code that will group data under a category and sub-categories and summarize unique data by using data suffix.
Attached is the sample spreadsheet.
Output1: From the raw file, group each data (File ID) under each category (Folder) and sub-category (Sub-Folder)
Output 2:
ColA: Summarize all File IDs
ColB: Unique suffix data (value before first dash of the File ID)
ColC: Value of Concatenated ColB Data, separated by Vertical Bar Pipe
Thank you!
Bookmarks