Forum Discussion
Solved
How to transform pdf report with multiple columns
I need to transform the report (partly shown above) from a pdf document into Power BI. I managed to prepare a pivot for 1 country, but struggle to add the other two countries. Please guide m...
Here is a blog post on how to do this from an Excel source by Gil Raviv
Generally the pattern is
- Transpose Table
- Fill Down
- Merge Columns by Delimiter
- Transpose Table
- Promote Headers
- Unpivot other Columns
- Split Column by Delimiter
- Rename Columns (set Column Type)
Adapt to your circumstance and data.
Here is a blog post on how to do this from an Excel source by Gil Raviv
Generally the pattern is
- Transpose Table
- Fill Down
- Merge Columns by Delimiter
- Transpose Table
- Promote Headers
- Unpivot other Columns
- Split Column by Delimiter
- Rename Columns (set Column Type)
Adapt to your circumstance and data.