novicecoder
New Member
I've an excel file which contains some ID's in column A and the text connected to them are in column B. The thing is the texts connected to each ID spill over multiple rows within column B. As a result If any ID is in row 1 in column A, the texts have been embedded in row 1,2,3 in column B. What I wish to do now is put the text in each ID's adjacent row (in a single cell) no matter how big they are. Check out the example file where I have already showed how the existing result look like and how they should be. I have addressed the existing and desired results by using before and after in the header area. I've attached an image below to show you the trouble I would like to get rid off. Thanks for any help.
