Forum Discussion
How to combine data in separate columns into a single row?
I have this set of 5000 data points. The data is from different years and are identified by the value in the first column. I am trying to get rid of the duplicate entry and combine the values from t...
do a power query on the data (left image)
make 2 copies of the query using duplicate not reference, the first duplicate query you keep the value to the left, the 2nd duplicate you keep the value to the right.
do a merge query matching the first column.
cheers
make 2 copies of the query using duplicate not reference, the first duplicate query you keep the value to the left, the 2nd duplicate you keep the value to the right.
do a merge query matching the first column.
cheers