Please see attachment. I would like to use the TextJoin function to join a list of cells back into groups.
On Sheet1 I started with 10 rows of data. I separated these into individual rows and then concatenated them with additional data on Sheet2.
I now need to put the 80 rows (column D) back into the original 10 rows of groups.