Grouping, Pivot, Transpose

[ilovecoding]

Here is my data where i have Instrument details separately for each account however i want all common instruments in row wise and a/c in columns and their relevant details in respective cell, Im not getting the desire output using these function, assist

[FinnCharlton · Accepted solution]

Hi @ilovecoding , a cross-tab tool will do the job here:

To change which values go in the cells, just change this option in the cross-tab tool:

Hope this helps!