Combining similar data into one cell similar to merged cells in excel

[ANarag]

I extracted data from several underlying tables and the output looks like the below: 

Agent Bank Market	Agent Bank Short Name	Agent Bank Domicile	Agent Bank Regulator	Contracting Party Name	Contracting Party Domicile	Contracting Party Regulator
Argentina	Citi Argentina	Argentina	Central Bank of Argentina (Banco Central de la República Argentina, BCRA)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Argentina	Citi Argentina	Argentina	Central Bank of Argentina (Banco Central de la República Argentina, BCRA)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Argentina	Citi Argentina	Argentina	Central Bank of Argentina (Banco Central de la República Argentina, BCRA)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Argentina	Citi Argentina	Argentina	National Securities Commission (Comisión Nacional de Valores, CNV)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Argentina	Citi Argentina	Argentina	National Securities Commission (Comisión Nacional de Valores, CNV)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Argentina	Citi Argentina	Argentina	National Securities Commission (Comisión Nacional de Valores, CNV)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Australia	Citi Australia	Australia	Australian Prudential Regulation Authority (APRA)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Australia	Citi Australia	Australia	Australian Prudential Regulation Authority (APRA)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Australia	Citi Australia	Australia	Australian Prudential Regulation Authority (APRA)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Australia	Citi Australia	Australia	Australian Securities Exchange (ASX)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Australia	Citi Australia	Australia	Australian Securities Exchange (ASX)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Australia	Citi Australia	Australia	Australian Securities Exchange (ASX)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Australia	Citi Australia	Australia	Australian Securities and Investments Commission (ASIC)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Australia	Citi Australia	Australia	Australian Securities and Investments Commission (ASIC)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Australia	Citi Australia	Australia	Australian Securities and Investments Commission (ASIC)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Australia	Citi Australia	Australia	Reserve Bank of Australia (RBA)	Citibank, N.A.	United States	Federal Reserve Board (FRB)
Australia	Citi Australia	Australia	Reserve Bank of Australia (RBA)	Citibank, N.A.	United States	Office of the Comptroller of the Currency (OCC)
Australia	Citi Australia	Australia	Reserve Bank of Australia (RBA)	Citibank, N.A.	United States	Federal Deposit Insurance Corporation (FDIC)
Australia	HSBC Australia	Australia	Australian Prudential Regulation Authority (APRA)	The Hongkong and Shanghai Banking Corporation Limited ("HSBC")	Hong Kong SAR	Hong Kong Monetary Authority (HKMA)
Australia	HSBC Australia	Australia	Australian Securities Exchange (ASX)	The Hongkong and Shanghai Banking Corporation Limited ("HSBC")	Hong Kong SAR	Hong Kong Monetary Authority (HKMA)
Australia	HSBC Australia	Australia	Australian Securities and Investments Commission (ASIC)	The Hongkong and Shanghai Banking Corporation Limited ("HSBC")	Hong Kong SAR	Hong Kong Monetary Authority (HKMA)
Australia	HSBC Australia	Australia	Reserve Bank of Australia (RBA)	The Hongkong and Shanghai Banking Corporation Limited ("HSBC")	Hong Kong SAR	Hong Kong Monetary Authority (HKMA)

However, I need the output to look like this: 

Agent Bank Market	Agent Bank Short Name	Agent Bank Domicile	Agent Bank Regulator	Contracting Party Name	Contracting Party Domicile	Contracting Party Regulator
Argentina	Citi Argentina	Argentina	Central Bank of Argentina (Banco Central de la República Argentina, BCRA) National Securities Commission (Comisión Nacional de Valores, CNV)	Citibank, N.A.	United States	Federal Reserve Board (FRB) Office of the Comptroller of the Currency (OCC) Federal Deposit Insurance Corporation (FDIC)
Australia	Citi Australia	Australia	Australian Prudential Regulation Authority (APRA) Australian Securities Exchange (ASX) Australian Securities and Investments Commission (ASIC) Reserve Bank of Australia (RBA)	Citibank, N.A.	United States	Federal Reserve Board (FRB) Office of the Comptroller of the Currency (OCC) Federal Deposit Insurance Corporation (FDIC)
Australia	HSBC Australia	Australia	Australian Prudential Regulation Authority (APRA) Australian Securities Exchange (ASX) Australian Securities and Investments Commission (ASIC) Reserve Bank of Australia (RBA)	The Hongkong and Shanghai Banking Corporation Limited ("HSBC")	Hong Kong SAR	Hong Kong Monetary Authority (HKMA)

Is that possible in Alteryx? 

[itohan]

You can probably do this with the Multi-Row Formula tool

[BS_THE_ANALYST]

@ANarag the answer is yes. Alteryx can do everything:
Please see below:
Output Table

Workflow:

Attached the workflow aswell

[BS_THE_ANALYST · Accepted solution]

@ANarag here's another way; refined it so it's more efficient. In the other solution there was some redundant steps:

[ANarag]

Thank you! I am new to Alteryx so this is extremely helpful.

[BS_THE_ANALYST]

@ANarag Welcome to Alteryx! Everyday is a school day here 😎😲