Ask Your Question
0

judge column text and combine cells

asked 2020-02-14 03:54:57 +0200

huiyung gravatar image

I need to add html for my product.

Each html represent an image to be placed for the product page. Each product has several images. I wish to combine all image html for each product.

For example: image description Column A is product no. There are three products with three different numbers. Column B is html which present different images. Column C is the result I wish to get. I just use "concatenate" function to get what I want. But I really hope to know any better way to automatically do the job.

I don't know how to make system to judge the same product no and combine the column accordingly.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-02-14 11:28:05 +0200

JohnSUN gravatar image

updated 2020-02-14 11:49:11 +0200

Try this: type to cell C2

{=IF(A2=A1;"";TEXTJOIN("";1;IF(A:A=A2;B:B;"")))}

(Finish entering the formula with the key combination Shift + Control + Enter, copy the resulting cell and paste it into the entire column C)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-02-14 03:54:57 +0200

Seen: 27 times

Last updated: Feb 14