Hi,

I have a sheet coming from another (stupid) program, with
- one line " client: name_of_the_client"
-on many lines, all the products ordered by the client


Of course, to sort this sheet, I would like a new column, with
name_of_the_client repeated in front of each corresponding product.

Can a vlookup formula put in column A the last previous cell from
column B beginning with "client" ?

From :
***********

Client: Mister Blabla
- toothbrush
- broom
-carpet
Client: Miss Blibli
- paper
- car
- plant

To:
**********

Mister Blabla | tootbrush
Mister Blabla | broom
Mister Blabla | carpet
Miss Blibli | paper
Miss Blibli | car
Miss Blibli | plant

Thanks for your help

François