Hello Guys,
I want to transpose data with 5 Columns to only 2 and a new row should be created for every column.
Source Data:
<tbody>
Berlin
1000
2000
3000
4000
5000
Dresden
500
300
300
300
300
</tbody>
After the macro, the data should be transferred to this result:
<tbody>
Berlin
1000...