Forum Discussion

Harmeet25's avatar
Harmeet25
Regular Visitor
3 years ago

Power Query - Combining different stores P&L reports

Hello Members,

 

Hope you are doing good.

 

I am facing issue with combining different stores P&L reports into Power Query in which many columns are showing nulls values as there is no data for particular years.

 

As per below screenshot data is showing one store below the others.

 

Let me know if anyone can help me on this issue.

 

Thanks in advance.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Harmeet25 , Make sure the column name are same and match in case, else append will move them under different headings.

    Also if there compelete blank rows, you can remove those