Use some cell values as categories for other values from the same column

Yeah, that data isn't very clean and no, not all categories have "-------" beneath them. I don't want to waste your time I will go for creating a massive conditional column.

I'm going to use excel for this as it will help me get the m language formula together. I will achieve that by writing parts of code in each column and then using "concat" function to bring it all together. No running away from hard categorising the data first I think 😄

Just thought that there is a button or other super simple solution that I wasn't aware of.

Thanks for your willingness to help,

Daniel