Transposing data with multiple columns

shravanvijayaprasad

I know this question has been asked and answered  a few times but I am struggling with it anyway. 

I am trying to take the below set up:

Fund	Fund Name	Period 1	Period 2	Period 1 Exchange	Period 2 Exchange
Fund 1	Fund Name 1	100	150	0.25	0.24
Fund 2	Fund Name 2	200	250	0.87	0.86

and change it to this:

Fund	Fund Name	Period	Exchange	Period Value	Exchange value
Fund 1	Fund Name 1	Period 1	Period 1 Exchange	100	0.25
Fund 1	Fund Name 1	Period 2	Period 2 Exchange	150	0.24
Fund 2	Fund Name 2	Period 1	Period 1 Exchange	200	0.87
Fund 2	Fund Name 2	Period 2	Period 2 Exchange	250	0.86

Any help would be appreciated.

P.S - I tried transposing twice but it creates Period 1 with Period 1 Exchange and Period 2 Exchange for fund 1

Thanks in advance!!

Jonathan-Sherman

Hi @shravanvijayaprasad,

This should achieve what you're looking to do. I also used two transpose tools but then filtered after to remove rows not required.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191118 - TransposingData.yxmd