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.
MarkS
Resolver IV
Resolver IVHi 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.