Transpose the value in the dataset

[Sshasnk]

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

Input:

fund	sub	date	name	value
ABC	12-ABC	12/1/2021	Sale	123.01
ABC	23-ABC	12/2/2021	Buy	145
ABC	34-ABC	12/3/2021	Purchase	156

Output:

fund	sub	date	sale	Buy	Purchase
ABC	12-ABC	12/1/2021	123
ABC	23-ABC	12/2/2021		145
ABC	34-ABC	12/3/2021			156

[DataNath · Accepted solution]

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.

[binuacs]

@Sshasnk Another way of doing this