Forum Discussion
How to create or merge specific columns based on other table instructions
I have "TableRAW" that contains many columns that start with "c" and a number. The rows may or may not have data for those c-numbers. I have a table "TableALIAS" that tells us there are 3 ...
v-juanli-msft
Community Support
Community SupportHi Anonymous
If my result is what you expect,please check my pbix file and follow steps on the right pane inside Edit queries.
Original sample data:
Final result 1, 2
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.