Power Query - Combining different stores P&L reports

[Harmeet25]

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.

[amitchandak]

@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