Forum Discussion
Merging Rows in Power Query
SumairChughtai Perhaps like in the attached file. I assumed that the raw looks like in the blue table. The Power Query output is in the green table, using only standard UI commands.
I would like to merge them as in the attached excel file.
The red font indicates what the data is in its original form.
The yellow highlighted is how I want the data to end up as one complete record.
Thank you for your interest in the problem.
Regards,
Sumair
SumairChughtai Perhaps like in the attached file. I assumed that the raw looks like in the blue table. The Power Query output is in the green table, using only standard UI commands.
- Hello Riny,
Your second table in the attached excel file (the one in green) is how I would like my format to be in Power Query. Kindly enlighten me as to how you came up with this solution.
Thank you! it kind of cracks me up this other user asking for help on a different thread, does not want to create at least a 20 to 40 rows of sample data, then the truth comes out ... turns out he's got 7,000 rows of data to organize. lol
I don't like to work on a solution based on a guess premise, its a time waster, I'd rather be watching movies on netflix if the challenge is based on a guess.
