Could not find a way to re-arrange data using the Arrange tool

[chrissgtan]

Hello Alteryx Community,

I need a way to re-arrange data in the following way.  I have attached the data file here too.  Thanks

[IraWatt · Accepted solution]

Hey @chrissgtan,

Here is one way to achieve this:

Any questions or issues please ask :)
HTH!
Ira

[binuacs · Accepted solution]

@chrissgtan one way of dong this 

[chrissgtan]

Thank you @IraWatt , I learn a new way to use the multi-row tool, together with with the transform tools, etc to achieve this.  Your help is much appreciated :-)

[chrissgtan]

Thank you @binuacs I learn a new way to use the RegEx formulation, together with with the transform tools, etc to achieve this.  Your help is much appreciated :-)

[IraWatt]

😄 great to hear @chrissgtan !