Forum Discussion
Merging data into one row
Hello 🙂 Please help. I need to merge all rows that have the same name on the "Owner" column and therefore no duplicate names, and merge the data that belongs to it. E.g in the screenshot bel...
Hi DianaDSTM - thank you for your question. You could consider Group By;
This will add the values in the "SF" and "WU" columns - ignore the Difference column when grouping. Then you are add a new "Difference" column based on [SF] - [WU].
Many thanks
Daryl