Data Required in Rows

[Rhaldhar]

Hi,

below data is the coming in Alteryx in 2 columns screen shot 1 . Can I get as screen shot. 2. please help. 

screen shot 1

Screen shot 2

Thanks,

Rajeev

[binuacs · Accepted solution]

@Rhaldhar One way of doing this

[FinnCharlton · Accepted solution]

Hi @Rhaldhar , here's how to transpose your data like this:

Hope this helps!

[Rhaldhar]

Thank you so much. It works.

[Rhaldhar]

Hi,

Can we also get data in the series below?

Month   May  Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr  Total

Amount  xx     xx   xx  xx   xx    xx   xx   xx     xx   xx    xx   xx    xx

[binuacs]

@Rhaldhar you can use the dynamic rename tool for this