Merging cells with same parent.
Hi,
I have three columns. Column 1 has family-numbers (sorted ascending). Column 2 has row-numbers (starting with 1 at the first instance of a new family) Column 3 has text. Example: FAM Row Text 1 1 These lines 1 2 belong to 1 3 eachother. 2 1 Do you want a 2 2 peanutbutter sandwich? 3 1 My daddy 3 2 lives in 3 3 a great big 3 4 block of flats. As you can see there is no fixed number of texts belonging to any family. Now I want something that merges for each family it's child-texts together, separated by a space, and after that, delete the duplicate family rows. Looking forward to your reply. |
All times are GMT +1. The time now is 03:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com