( by )
Hi, I'm trying to merge the text in several rows based on a common ID# in a different field. For example, I have:
Have a look at the following screenshot of "Sheet1":
And following screenshot of "Sheet2":
In the above sheet "Sheet2", I have the following formula in Cell A2:
the following formula in Cell B2:
and then you can drag the above formula to Cell B3, B4... and so on... as far as needed...