Hi, I am completely new to Alteryx and need help to get the below output. Thank you in advance. Sample Input: Col ACol BCol CCol DCol ECol FCol GCol HCol IABC1231123456ABCAxUSD4/20/20214/27/20210.042DEF1871123456ABCAxUSD2/19/20212/26/20210.042GHF1971123456ABCAxUSD3/19/20213/26/20210.042HML3211123456ABCAxUSD1/20/20211/27/20210.042LKH4561123456ABCAxUSD5/20/20215/28/20210.042LMB8791123456ABCAxUSD6/18/20216/28/20210.042MNC54651654789XYZBxUSD6/18/20216/28/20210.034914LU23551654789XYZBxUSD6/18/20217/8/20210.028417NY98551654789XYZBxUSD6/18/20216/28/20210.002449GHF1975459873PQRSCxUSD6/18/20216/18/2021-0.02352DEF1875459873PQRSCxUSD6/18/20216/8/2021-0.04949ABC1235459873PQRSCxUSD6/18/20215/29/2021-0.07546 Sample output needed as per below: Col A/Col BCol CCol DCol ECol FCol GCol HCol I1123456ABC ABC123 AxUSD4/20/20214/27/20210.042DEF187 AxUSD2/19/20212/26/20210.042GHF197 AxUSD3/19/20213/26/20210.042HML321 AxUSD1/20/20211/27/20210.042LKH456 AxUSD5/20/20215/28/20210.042LMB879 AxUSD6/18/20216/28/20210.04251654789XYZ MNC546 BxUSD6/18/20216/28/20210.034914LU235 BxUSD6/18/20217/8/20210.028417NY985 BxUSD6/18/20216/28/20210.0024495459873PQRS GHF197 CxUSD6/18/20216/18/2021-0.023519DEF187 CxUSD6/18/20216/8/2021-0.049487ABC123 CxUSD6/18/20215/29/2021-0.075455

Merging rows

Hi,

I am completely new to Alteryx and need help to get the below output. Thank you in advance.

Sample Input:

Sample output needed as per below:

Workflow

Here is my take on the usecase

Workflow:

Hope this helps : )

Hi @SaiJanani , it will probably take a combination of a Crosstab tool, a Transpose tool and a Summarize tool. The Tool Mastery Index has links to help learn many of the tools.

Here is my take on the usecase

Workflow:

Hope this helps : )

Thank you, problem solved