vishesh10667
New Member
- Joined
- Nov 26, 2019
- Messages
- 18
- Office Version
- 2007
- Platform
- Windows
Hi, I have a list of items in Column B and each items in B should concatenate with the list in column C.
For example: Cell B1: Reebok, and Cell C1: T-Shirt, C2: Shoes, Etc.,
and Cell B2: Lacoste, and Cell C1: T-shirt, C2: Shoes, Etc.
Output : D1: Reebok T-shirt, D2: Reebok Shoes, D3: Lacoste T-shirt, D4: Lacoste Shoes etc.
Is there any formula to concatenate like this?
For example: Cell B1: Reebok, and Cell C1: T-Shirt, C2: Shoes, Etc.,
and Cell B2: Lacoste, and Cell C1: T-shirt, C2: Shoes, Etc.
Output : D1: Reebok T-shirt, D2: Reebok Shoes, D3: Lacoste T-shirt, D4: Lacoste Shoes etc.
Is there any formula to concatenate like this?