Forum Discussion
Merging rows with duplicate values
I have data in Power BI which has been obtained through an API linked to my companies LiveChat service. The data comes in as one row and each Agent and their category as a separate column. So there a...
Ahmedx
Super User
Super UserThe simplest solution is to look at all 8 columns and fill them in; except for the last ninth column, do not touch it.
You may first need to convert empty values to null
then filter the last column (column 9) removing null values