Transposing table with pivoting (not Transpose node)

Hello again,

I’m encountering another problem which is not easily solved via Table Transposer Node.

Currently my table looks something like this:

| Country     | Images | Templates | Chapters |
| USA         | 0      | 38        | 1        |
| Belgium     | 23     | 2         | 2        |
| Netherlands | 4      | 345       | 0        |
| Switzerland | 32     | 21        | 0        |
| Germany     | 0      | 0         | 54       |
| Austria     | 0      | 1         | 12       |

Obviously, I need columns and rows transposed. Easily done in Excel but in Knime I’ll encounter the error “Execute failed: Unsupported column type ‘?’”.

I also tried the Column Auto Type Cast Node but it’ll corrupt the data types of the results in the matrix (String instead of integer).

Is there any way I can transpose via Unpivot and Pivot? If so, how may an attempt look like?

Thank you!