Grouping by Categories and SubCategories

Dear Experts,
This is related to my previous post, but with different raw data set and format.
I need help with writing a macro that will group data under different categories and sub-categories and summarize unique data by using data suffix.

Attached is the sample spreadsheet.

Output1 Sheet: From the "Raw Data" sheet, group each data (File ID) under each category (Folder) and sub-category (Sub-Folder)

Output 2 Sheet:
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!

@maras_mak! Thank you. That works! Faster and more efficient by miles than the code I initially built. I appreciate your help!