Arrange the dataset based on column name

[Sshasnk]

I have a dataset where I have column fund/account/purchase/sell etc is the first line but I have to arrange the values below.

Input:

Fund	account	amount	purchase	sell	buy
ABC	123	489	562	58	456
NLM	154	456	314	54	23
BC	145	562	23	156	489
Fund	account	purchase	buy
ABC	1456	789	456
GHL	48	145	56
Fund	account	amount	sell
HLK	1546	231	235

The fund column will always be there while others will keep changing 

Output:

Fund	account	amount	purchase	sell	buy
ABC	123	489	562	58	456
NLM	154	456	314	54	23
BC	145	562	23	156	489
ABC	1456		789		456
GHL	48		145		56
HLK	1546	231		235

[JosephSerpis]

Hi @Sshasnk if you use a filter that should tackle your challenge.

[IraWatt]

Hey @Sshasnk,

You could filter out the rows containing Fund to reach your result:

definitely check out the getting started learning path on the community it has some great and quick interactive videos which will help you get started with the basic tools in Alteryx: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Christina_H]

You need to separate out your different datasets to be able to line up the figures correctly.  See attached workflow.

[DenisZ]

Please see attached workflow

[Sshasnk]

@JosephSerpis @IraWatt Please check the output of yours, It is wrong.

[Felipe_Ribeir0]

Hi @Sshasnk 

One way of doing this, similar to @DenisZ approach

The idea is to use a macro to union the datasets one by one using the column name as reference.