Forum Discussion
khaycock
6 years agoHelper I
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...
v-lid-msft
6 years agoCommunity Support
Hi khaycock ,
We can try to use the following measure to meet your requirement:
1. unpivote those columns
2. remove the attribute columns
3. remove duplicate values in value column
4. then you can merge with other queries:
Best regards,