How to pivot table?

Hello, I have a table like this:

 

System ErrorAffected RegionTotal Error 1City2Error 1Village5Error 2City 7Error 2Village3

 

What I would like to have is this:

Affected Region

 

Error 1Error 2City

 

27Village

 

53

 

What transformer do I need to use to change the table structure?

Thanks.