Transpose the value in the dataset

Question

I have a dataset that I want to transpose based on fund

Input:

fundsubdatenamevalueABC12-ABC12/1/2021Sale123.01ABC23-ABC12/2/2021Buy145ABC34-ABC12/3/2021Purchase156

Output:

fundsubdatesaleBuyPurchaseABC12-ABC12/1/2021123  ABC23-ABC12/2/2021 145 ABC34-ABC12/3/2021  156

DataNath · Accepted Answer

Hey @Sshasnk, the input you have at the minute is already Transposed and so you'll need to Cross-Tab it to get the desired output:

If you're fussy about the fields being in that order then you can use the following approach:

This assigns an ascending number to each field name, which is then used during the Cross-Tab to maintain the order, before using the lookup feature of Dynamic Rename to change this back to the original header it corresponds to.