Forum Discussion
Helper IIUse some cell values as categories for other values from the same column
Helper IIHi BA_Pete,
thanks for your quick reply. Unfortunately, the solution didn't work for me as there are many unique values and nearly none of them consist of words that would contain a category name in them.
I think that I will have to force myself to write a long conditional column and also use excel to first categorise everything by hand. Ech..
Super User
Hold your horses my man! Where there's a will, there's a way.
Was my broad understanding of your requirement correct - do you essentially want that output, but without hard-coding the header names?
If so, then do the header names that you want carried down ALWAYS have a '----------' row directly underneath them? We could use this characteristic to dynamically identify them.
Pete
- Danielnir
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
- BA_Pete
No problem, best of luck 👍
Pete