I am merging two datasets and one of them has duplicates and it’s causing allot of issues. I want to remove the duplicate and create a new column.
I have applications that are monitored by 1 of three tools (Dynatrace, SCCM, Tivoli). The data is currently set up so that the application name is listed multiple times representing that it has more than one monitoring tool. I want to make three new columns in PQ, each column representing the monitoring tool.
Moving Duplicate Values from a Row to a Column.pbix (21.6 KB)
Tools.xlsx (10.6 KB)
End Result.xlsx (10.6 KB)