Forum Discussion
Combining Data
Hello, Is it possible to create extra lines based on data in other columns? I have three fields that I need to be one field so it can be a generic filter: I'm conscious that amending th...
Hi v-lid-msft
Thanks for the help. The only issue is that the rest of this table holds keys so I can't just remove duplicates as it will remove data. The unpivot thing worked initially but because it then duplicated the ID, it messed up the relationship. Here is a snippet of the whole table's data so you can see what I mean.
Hi,
Please show the exact result you are expecting.