Forum Discussion
Solved
Merging Rows in Power Query
Hi, Need to learn how to merge a row in data table when a record is broken into two rows Also the record is in the incorrect column. There are a number of more columns so the transpose op...
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.
SumairChughtai Would be helpful if you could explain how you would wan the end result to look like.
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!
