P
Pluggie
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.
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.