Manage data in excel after excel export from Mendix

Hi,   I have some data output from my excel exporter. Now I want to transpose the vertical data into rows. I have a row ID for each part of data that should be shown horizontally in the respective columns.  Any idea how to do this? Here's my current and desired situation (after applying the right formula or macro?)      
0 answers