Concatenate rows and display data in a new column

[SaiJanani]

Hi,

I am trying to concatenate two rows, Col A and Col B and display it in a new row. Sample data below:

Sample Input:

Col A	Col B	Col C	Col D	Col E	Col F	Col G	Col H	Col I
ABC123	USD	LU567				ABC	BMN
DEF187	EUR	LU698	1	123	648	963	753	428
GHF197	KWD	LU167				XYZ	ERTS	LOP
HML321	AUD	LU348	51	789	324	423	658	157
LKH456	USD	LU571				PQRS	WER	GHF
LMB879	AUD	LU879	5	654	148	875	6321	637

Sample Output:

Col A	Col B	Col C	Col D	Col E	Col F	Col G	Col H	Col I	Col J
ABC123	ABC123USD	USD	LU567				ABC	BMN
DEF187	DEF187EUR	EUR	LU698	1	123	648	963	753	428
GHF197	GHF197KWD	KWD	LU167				XYZ	ERTS	LOP
HML321	HML321AUD	AUD	LU348	51	789	324	423	658	157
LKH456	LKH456USD	USD	LU571				PQRS	WER	GHF
LMB879	LMB879AUD	AUD	LU879	5	654	148	875	6321	637

[atcodedog05 · Accepted solution]

Hi @SaiJanani 

Here is one way of doing it.

Workflow:

Hope this helps : )

[SaiJanani]

Thank you 🙂

[atcodedog05]

Happy to help : ) @SaiJanani 

Cheers and have a nice day!