Arrange the dataset based on column name

Question

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 accountamountpurchasesellbuyABC12348956258456NLM1544563145423BC14556223156489Fund accountpurchasebuy  ABC1456789456  GHL4814556  Fund accountamountsell  HLK1546231235

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

Output:

Fund accountamountpurchasesellbuyABC12348956258456NLM1544563145423BC14556223156489ABC1456 789 456GHL48 145 56HLK1546231 235

Felipe_Ribeir0 · Answer

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.

Arrange the dataset based on column name.yxzp

Sshasnk · Answer

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

DenisZ · Answer

Please see attached workflow

union_wf.yxzp