Forum Discussion

vinothkumar1990's avatar
vinothkumar1990
Helper II
4 years ago
Solved

Power Query - Excel rows shift up

Hi All,   I have a excel and i want to generate the report out it. The data population in the excel is some what different, so i want to convert them in my own format in Power BI. Refer the below ex...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    In the first column, you can 'replace values' on blank or "" with null (You want to get null in all those cells - apart from the legitimate values)

    Then use 'Fill Down' on the first column.

    Then Filter out the blank rows from column2 header 

HotChilli's avatar
HotChilli
Community Champion
4 years ago

In the first column, you can 'replace values' on blank or "" with null (You want to get null in all those cells - apart from the legitimate values)

Then use 'Fill Down' on the first column.

Then Filter out the blank rows from column2 header