Data Cleansing

[Hadill]

Hello,

I am creating a dashboard on Power BI that reads data from many excel sheets available in a SharePoint site.

I understand that the data in the excel sheet should have a specific form/layouts, so the Power BI can recognize them (Data should be in columns, no merged cells, etc) .

The problem is the excel sheets that I use which created by colleagues or extracted form tools, have different forms/layouts that the Power BI can't recognize. (Such as Merged cells or horizontal columns)

What do you usually do in this case?

Create a new sheet that reflects the same data in the required layouts, then link the new sheet to the Power BI?

But sometimes this way doesn’t work!

Or, you have different suggestions?

Thanks in advance

[Hadill]

Thank you @Idrissshatila for your helping.

I have diffrent kind of data sorting that the pivot table doesnt work with, could you please help me in this too?

below screenshot. 

Thanks again 

[Idrissshatila · Accepted solution]

Hello @Hadill ,

You could try to work on it and shape it in power query, check this link to learnabout pivot and unpivot https://databear.com/power-bi-pivot-and-unpivot-columns/

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin