Forum Discussion
Solved
Importing Excel into PBI
Hello, I need to import an excel file from the web into PBI. That excel file has text written over multiple cells and I need the text in every cell that it is written over. It is a header for m...
The solution was to flip the table (make rows into columns and columns into rows) and then use the "fill columns" function and then filp again.
Then the null-cells under the cell that the text is written in are also filled with that text and when different text comes up the following nulls are filled with that text.
The solution was to flip the table (make rows into columns and columns into rows) and then use the "fill columns" function and then filp again.
Then the null-cells under the cell that the text is written in are also filled with that text and when different text comes up the following nulls are filled with that text.