Forum Discussion
Merge Rows into one row parsing two columns
Hello there, hope this is not a redundant thread. As in picture, I got a table where are stored users for certain applications and their roles. It could be reaaally nice to have one row for every...
Hi Stefano,
This looks like an XY Problem waiting to happen.
What are actually trying to achieve overall, as you're moving the data away from the most efficient structure here.
Power Query isn't really designed to format your data how you want it to look, but rather to transform/aggregate it into an efficient dataset for formatting later in Excel or Power BI.
Pete
Well, I'm sorry for that.
Still, I don't know how to do it neither in powerbi, I'm trying to figure out how...
