Grouping Data by Category and SubCategories and Summarizing unique data

[mgcarino14]

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!