Forum Discussion
Merge a row with the previous one
Hello, I am new to Power BI and I struggle merging some rows. I have rows which have a column name in it and the actual data of those columns in the next line, like this: ...
Hi Anonymous,
Another way (if the null for key 2 and 3 are necessary to be kept) is to use some other string (or value) that is not in the dataset as a marker instead of null when replacing the TITLE1 and TITLE2 for example 'ZZZZZ'.
Then you can fill down on the UniqueKey column.
Then you can filter out the marker text from the Table1 and Table2 columns.
Thanks for the answers. I did a Fill down on the Key column and other columns I need.
ImkeFMaybe my exemple was not exhaustive enough, but Fill up on the columns would not work in my case because Column 4 can be null sometimes, and in that case I don't want the data to be duplicated in the line above that has a different key.