Forum Discussion
Solved
Delimiter to be used
Dear Experts, I have a data like below:- So, each sub Packets[x], if has data will have Common and Chain as below, I want to bring Chains in the same level as the common, ...
Perhaps the attached file with a PQ solution does what you have in mind. I assumed that you do not need to keep the ancient way the headers are presented. It looks like a report that came from a matrix printer in the 1980ies.
I'll leave it to you to perform the last step and properly name the columns in PQ.
this was more challenging than I thought it would be. in the attach i got something close. could tweak further but hoping it is close enough for what you need. also wondering if power query might have better solution option but i'm not great in that tool yet.