Forum Discussion
Solved
Grouped Rows in Excel - Reversing the process in Power BI
Hi Team, I've got some data that comes from Excel - on the Excel side the rows are grouped so we end up with something like this in Power Query: I'm trying to avoid doing anything manual on...
CallumJ , if there are return character, use clean In power query
Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4
If there are multiple rows in power bi with empty rows, check to fill up and down
Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
CallumJ , if there are return character, use clean In power query
Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4
If there are multiple rows in power bi with empty rows, check to fill up and down
Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI
I was racking my brain and it was that simple 😀 Thanks!
