Hello everyone.
I have this problem, see the image for more illustration:
[img ]https://lh5.googleusercontent.com/hG3qj1nlSedB4-7nbFY2NOLJ6sG41f9VYBofeZecwiRngKxwnFIsHJ9UOg8GF6eddq35TM4JyWtdew=w1536-h749[/img]
Column A: each cell contains one word
Column B: each cell contains multiple line, each line contains a sentence, short or long.
I want to combine Column A with Column B, thus Column A is the beginning of every line in Column B (see the photo attached).
BTW, I have access to Kutools in Excel.
With best regards,
Akbar
I have this problem, see the image for more illustration:
[img ]https://lh5.googleusercontent.com/hG3qj1nlSedB4-7nbFY2NOLJ6sG41f9VYBofeZecwiRngKxwnFIsHJ9UOg8GF6eddq35TM4JyWtdew=w1536-h749[/img]
Column A: each cell contains one word
Column B: each cell contains multiple line, each line contains a sentence, short or long.
I want to combine Column A with Column B, thus Column A is the beginning of every line in Column B (see the photo attached).
BTW, I have access to Kutools in Excel.
With best regards,
Akbar