Transpose query

[PrashantJP]

Hi Folks,

I have a query regarding transpose. I tried it quite a few times but I am unable to get the desired output. Could you please help?

Below is the input:

O/L SLA	3-May	4-May	5-May	6-May	7-May
	Mon	Tue	Wed	Thu	Fri
Americas
FIG	Y	Y	Y	Y	Y
Funds	Y	Y	Y	Y	Y
Hedge Funds	Y	Y	Y	Y	Y
Corp	N	Y	Y	Y	N
RE	N	N	N	Y	N
Latam	N	N	N	Y	N
EMEA
FIG	Y	Y	Y	Y	Y
Corp	Y	Y	Y	Y	Y
EM	Y	Y	Y	Y	Y
Total	6	7	7	9	6
SLA %	67%	78%	78%	100%	67%

The output should be as follows. Just need Date and SL % to be transposed as below.

Date	SLA%
5/3/2021	67%
5/4/2021	78%
5/5/2021	78%
5/6/2021	100%
5/7/2021	67%

Appreciate your help!

[atcodedog05]

Hi @PrashantJP 

Here is how you can do it.

Workflow:

Hope this helps : )

[PrashantJP]

Can you please do the same with attached file?. I am unable to replicate the workflow when I use excel file input

[atcodedog05 · Accepted solution]

Hi @PrashantJP 

Here is the updated workflow

Hope this helps : )