Combine multiple columns and data sets into individual columns

[MKTax]

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.97483
Account 2		0.035829		0.043887		0.057242		0.061794		0.02517

And turn it into:

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

Thanks for your help in advance!

[BenMoss · Accepted solution]

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

[MKTax]

Thanks BenMoss! I really appreciate it!

Yes, unfortunately the data isn't clean and it is hard to organize from the files that are sent to us. 

I actually have a couple additional questions if you don't mind answering them. 

1. I actually need the "A,B,C,D," etc. included at the top. They are actually the names of partners and I'm ultimately trying to figure out how much of each account each partner has a claim in. What I'm hoping to be able to get my workpaper to is:

	Account 1	Account 2
Partner A	0.7	0.3
Partner B	0.9	0.1
Partner C	0.8	0.2

I know I have a long way to go though, as the data isn't in the proper format, so I'm trying to get it closer.

2. Most of the files that I get are unfortunately wide and skinny, instead of long and thin. Any ideas on how to fix that? 

Thanks again!

MK

[BenMoss · Accepted solution]

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

[MKTax]

Thanks BenMoss! I appreciate the help!

Yeah I wish, unfortunately we don't get clean data from others, even when we request it. Either way, thanks for the help!