Good morning, I'm trying (& failing!) to join text, based on a mixture of different formula and have got in a tangle!
Raw info is laid out below in Columns A to C.
Column B = the components that have been bought by which customer (sometimes blank)
Column C = name of customer (sometimes blank)
What I'd like to do is (using table below as an example):
1. Add a column like Col F = Unique Customers (ignoring blanks, A to Z)
2. Add a column like Col G = a "Text join" of the components that they have bought (ignoring blanks), but only one of each type (unique), A to Z.
My raw data is on a sheet of about 1,000 rows.
Thanks for any help you could provide.
Best
Neil
Raw info is laid out below in Columns A to C.
Column B = the components that have been bought by which customer (sometimes blank)
Column C = name of customer (sometimes blank)
What I'd like to do is (using table below as an example):
1. Add a column like Col F = Unique Customers (ignoring blanks, A to Z)
2. Add a column like Col G = a "Text join" of the components that they have bought (ignoring blanks), but only one of each type (unique), A to Z.
Make | Component | Customer | Customer | Components-Joined | ||
Lucas | Wing | JJ | Dave Kav | Bulb;Clutch | ||
Regular | Clutch | Dave Kav | Dave Lassitt | Bonnet | ||
Vauxhall | Wing | JJ | Clutch;Wing | |||
Vauxhall | Bonnet | Peter W | Bonnet | |||
Regular | Dave Lassitt | |||||
Jaguar | Bonnet | Dave Lassitt | ||||
Land Rover | Bonnet | Peter W | ||||
Regular | Clutch | JJ | ||||
Generic | Bulb | Dave Kav | ||||
Jaguar | Bonnet | Dave Lassitt | ||||
Jaguar | Bonnet | Dave Lassitt | ||||
My raw data is on a sheet of about 1,000 rows.
Thanks for any help you could provide.
Best
Neil