Changing data structure (crosstab)

[gkcekucuk]

Hi, 

I need help with restructuring some data. 

The data schema I am working with has tables such as products, purchasers, sellers etc. I am trying to build a view to see the transactions clearly. The purchaser and seller information is kept in the attached sample data (current data sheet) and I would like to get it to the structure in the Desired Data sheet. 

I have created a workflow to do this with a bunch of cross-tab tools and a join multiple tool (also attached) but it is working really slowly. Is there a more efficient way to do this? 

Thanks!

[DataNath · Accepted solution]

Hey @gkcekucuk, how does something like this look? The main part of the workflow stops at the Cross-Tab. The Dynamic Rename/Multi-Field Formula are just for a little bit of cleanup:

Edit: Added in an extra step to maintain the desired order of fields:

[Hamder83]

Hi @gkcekucuk 

Could it be something like this?

[gkcekucuk]

Hi @DataNath . I implemented it and it worked! Thank you :)