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 khaycock ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,