Merge current row and the below row and display the data in a new column

[SaiJanani]

Hi,

In the below sample, I am trying to combine the data in the 1st and 2nd row from Col A and display that combined data in both 1st and 2nd rows in Col B keeping other column's data intact

Sample Input:

Col A	Col B	Col C	Col D	Col E	Col F
ABC123	LU567		ABC	BMN
USD		1	963	753	428
DEF187	LU698		XYZ	ERTS	LOP
EUR		51	423	658	157
GHF197	LU167		PQRS	WER	GHF
KWD		5	697	6321	637
HML321	LU348		TUR	RWD	FGH
AUD		97	421	482	854
LKH456	LU571		PWS	CFG	QWER
USD		102	875	321	754
LMB879	LU879		LCX	QWE	NJI
AUD		863	637	167	785

Sample Output:

Col A	Col B	Col C	Col D	Col E	Col F	Col G
ABC123	ABC123USD	LU567		ABC	BMN
USD	ABC123USD		1	963	753	428
DEF187	DEF187EUR	LU698		XYZ	ERTS	LOP
EUR	DEF187EUR		51	423	658	157
GHF197	GHF197KWD	LU167		PQRS	WER	GHF
KWD	GHF197KWD		5	697	6321	637
HML321	HML321AUD	LU348		TUR	RWD	FGH
AUD	HML321AUD		97	421	482	854
LKH456	LKH456USD	LU571		PWS	CFG	QWER
USD	LKH456USD		102	875	321	754
LMB879	LMB879AUD	LU879		LCX	QWE	NJI
AUD	LMB879AUD		863	637	167	785

[Luke_C · Accepted solution]

Hi @SaiJanani 

Here's an example of how to do this with the multi-row formula tool. I assume the 2nd row is currency codes, so I use the expected length of 3 to do the logic. 

[RolandSchubert · Accepted solution]

Hi @SaiJanani 

the Multi-Row Formula tool should solve your problem.

Let me know if it works for you.

Best,

Roland

[SaiJanani]

Hey, thanks.. both worked for me..