Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

How to Clean and Sort Data from a Complex Excel Table

Hello good day!
they gave me an excel file where it contains a table with data ordered as follows which I do not understand how to sort them to handle them from powerbi since it has combined headers (escapes my knowledge).

the table contains its column "SUB CENTER OF COST BARRACKS" and "Labor" that would be related to another table of Area that I keep created, my problem begins with the following columns that detail the count of people by "week" and then is detailed in day as seen in the image. I must also say that the count that carries the table by date (week and detail in day) I want to relate it to a calendar table to have it related to my model.

wzuniga_0-1635861523439.png
What are the steps I should follow to be able to handle this data in the best way and relate it to my model?

Thank you very much for your help and time!