How to rearrange data in to a matrix?

[evelina1]

Hello, 

I am working on a workflow in which I need to turn a dataset that's presented in columns into a sort of matrix where data is grouped by both columns and rows.  Please see an example data set below:

GL Account	Fund Name	Strategy Name	Channel Name	Amount
11111	A	XX	ABC	100
11111	A	YY	ABC	100
11111	A	ZZ	ABC	100
11111	B	XX	ABC	100
11111	B	YY	DDD	100
22222	A	ZZ	ABC	100
22222	A	XX	ABC	100
22222	A	XX	ABC	100
22222	B	YY	ABC	100
22222	B	ZZ	DDD	100

And my goal is to turn it into a dynamic matrix so that data is grouped by one column variable and several row variables.  The end result / goal is this:

Fund Name  -->	A	A	A	B	B	B	B
Strategy Name  -->	XX	YY	ZZ	XX	YY	YY	ZZ
Channel Name -->	ABC	ABC	ABC	ABC	ABC	DDD	DDD
GL Account
11111	100	100	100	100		100
22222	200		100		100		100

Is this something that anyone could help out with?  I've tested several ideas with no avail.  Thank you so much in advance! 

Regards,

Evelina 

[Qiu]

@evelina1 
Hope this would work for you. 😁