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.
28 Replies
When you say:
Need to learn how to merge a row in data table when a record is broken into two rows
I don't see that in your sample file
(looking at Transaction number and Reference fields/columns),
so in what context does the above statement refer to?
cheers
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
The kind of issue that definitively requires > 1 example... Put together something (attached) with what you provided + added a couple of extra broken records
NB: When a [Transaction Number] is broken as 2 records (what you gave us with: when a record is broken into two rows)
- The 2 records must be consecutive in the Source Table/file (otherwise I don't see how you're going to resolve this...)
- The 2nd partial record is "added" to the 1st available location in the previous record
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.
