Forum Discussion
Really important!!!! Dublicates in rows, except in two columns - split in to #2, #3, #4 columns
Hi everyone,
I have the following problem. I have a large table that often contains duplicates except in two columns.
Now I want to remove these duplicates, but split the columns that contain different values into new columns. E.G. ...#2, ...#3.
I want to create this for both columns.
Here you can see the two column, which cotains different values.
And here I have the expected solution:
I have to get this done today -.-
I hope you guys can help me ❤️
Thanks in advance,
Abba!
2 Replies
What is the logic to get from your data to the expected result? We need data too. See below.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
