Forum Discussion
Solved
Changing excel sheet on import
Hi, Trying to import data from an excel file into Power BI. The data looks like this: What I need to do is end up with the data looking like this: Is there any way of achieving thi...
In Power query select the first column (with the team)
then go in Transform --> Fill --> Down
In Power query select the first column (with the team)
then go in Transform --> Fill --> Down
Amazing. Thank you!