I have one cell that has names separated with alt + enter. On the other cell, I have additional information on those names (also separated by alt+enter).
What I need to do is to concanate those cells "line by line". So instead of adding the 2nd cell to the end of the 1st cell, I need to match information on each line.
Combined cell should be
Name 1 Information 1
Name 2 Information 2
Name 3 Information 3
This excel sheet illustrates the problem and the desired result:
Can anyone help me?