Forum Discussion
Solved
Org Template from Excel Sheet converted into extractable data - Need Help
Hello Everyone, I have a template I need to re-configure to get extractable and legible data into PowerBI. The template currently is set up for end users to have to modify columns and rows that w...
Hi nicoleclancy91 ,
The Excel file appears to have a non-tabular structure, with a lot of empty or merged cells. To make it extractable and suitable for Power BI, we need to:- Identify relevant data (e.g., total hours per discipline).
- Unpivot (reshape) the data into a structured table format.
- Remove unnecessary empty rows and columns.
I'd clean and restructure the data into a tabular format.
Best regards,
DataNinja777
Super User
Super UserHi nicoleclancy91 ,
The Excel file appears to have a non-tabular structure, with a lot of empty or merged cells. To make it extractable and suitable for Power BI, we need to:
- Identify relevant data (e.g., total hours per discipline).
- Unpivot (reshape) the data into a structured table format.
- Remove unnecessary empty rows and columns.
I'd clean and restructure the data into a tabular format.
Best regards,