How to transform pdf report with multiple columns

[RonLieuw]

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 me in right direction.

Thanks

[MarkS · Accepted solution]

Here is a blog post on how to do this from an Excel source by Gil Raviv

http://blogs.technet.com/b/gilraviv/archive/2015/10/18/transform-any-nested-tables-to-pivot-table.as...

Generally the pattern is

1. Transpose Table
2. Fill Down
3. Merge Columns by Delimiter
4. Transpose Table
5. Promote Headers
6. Unpivot other Columns
7. Split Column by Delimiter
8. Rename Columns (set Column Type)

Adapt to your circumstance and data.