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

Question

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 ACol BCol CCol DCol ECol FABC123LU567 ABCBMN USD 1963753428DEF187LU698 XYZERTSLOPEUR 51423658157GHF197LU167 PQRSWERGHFKWD 56976321637HML321LU348 TURRWDFGHAUD 97421482854LKH456LU571 PWSCFGQWERUSD 102875321754LMB879LU879 LCXQWENJIAUD 863637167785

Sample Output:

Col ACol BCol CCol DCol ECol FCol GABC123ABC123USDLU567 ABCBMN USDABC123USD 1963753428DEF187DEF187EURLU698 XYZERTSLOPEURDEF187EUR 51423658157GHF197GHF197KWDLU167 PQRSWERGHFKWDGHF197KWD 56976321637HML321HML321AUDLU348 TURRWDFGHAUDHML321AUD 97421482854LKH456LKH456USDLU571 PWSCFGQWERUSDLKH456USD 102875321754LMB879LMB879AUDLU879 LCXQWENJIAUDLMB879AUD 863637167785

Luke_C · Accepted Answer

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 Answer

Hi @SaiJanani

the Multi-Row Formula tool should solve your problem.

Let me know if it works for you.

Best,

Roland