How to merge rows in Power Query if some columns are duplicate.
Unfortunately I can't post an example, but the data I'm working with first needed the Pivot Columns function performed to move toward columnar data structure. The result is that I have multiple rows for the same metadata, with other columns containing values in one of the rows. There are about 70 columns involved!
I'm manually merging them with ASAP-Utilities, due to a time crunch (I'm not good/fast at VBA from scratch), but there can be thousands of otherwise duplicate rows that I need to combine to one record per transaction. I've seen "GroupKind", maybe, but am not expert enough in PQ/PP to know how to use it (if it's even the right tool).
Thanks All!
Roughly, the data looks like this:
And I need:
Unfortunately I can't post an example, but the data I'm working with first needed the Pivot Columns function performed to move toward columnar data structure. The result is that I have multiple rows for the same metadata, with other columns containing values in one of the rows. There are about 70 columns involved!
I'm manually merging them with ASAP-Utilities, due to a time crunch (I'm not good/fast at VBA from scratch), but there can be thousands of otherwise duplicate rows that I need to combine to one record per transaction. I've seen "GroupKind", maybe, but am not expert enough in PQ/PP to know how to use it (if it's even the right tool).
Thanks All!
Roughly, the data looks like this:
StaticData1 | StaticData2 | VariableData1 | VariableData2 | VariableData3 |
Joe | 123 | OH | ||
Joe | 123 | Toledo | ||
Joe | 123 | 2.50 | ||
Fred | 456 | MI | ||
Fred | 456 | MI | ||
Fred | 456 | Grand Rapids | ||
Fred | 456 | 1.25 | ||
And I need:
StaticData1 | StaticData2 | VariableData1 | VariableData2 | VariableData3 |
Joe | 123 | OH | Toledo | 2.50 |
Fred | 456 | MI | Grand Rapids | 1.25 |