Combine multiple columns and data sets into individual columns

Question

Hi everyone!

I need help combining multiple sets of columns into a single column. I am trying to take this:

A B C D E Account 1 0.964171 0.956113 0.942758 0.938206 0.97483Account 2 0.035829 0.043887 0.057242 0.061794 0.02517

And turn it into:

ABCDEAccount 10.9641710.9561130.9427580.9382060.97483Account 20.0358290.0438870.0572420.0617940.02517

Thanks for your help in advance!

BenMoss · Accepted Answer

Hi @MKTax there's certainly a few ways to do this in Alteryx.

As I say in a lot of posts on the community, restructuring your data into a 'long and thin' format is usually the key to solving your data challenge and that certainly applies in this case.

Take a look at the solution attached and let me know if you have any questions.

Ben

BenMoss · Accepted Answer

Okay, regards your first point, that's relatively straight forward, we just need to pivot your data a couple of times in each direction to essentially reverse the orientation, as shown in the attached example.

Regards your 2nd point, it's hard to say the best approach, most organisations do tend to store data in the 'short and wide' format.

Ben