Price with duplicates, how to remove them?

Question

excel

Good afternoon! They threw off the price, there, for example, 1 product with the same product code can be repeated 10-30 times. But there are differences: the fullness of the columns. For example, line 1 contains a photo, line 2 contains a video, line 3 contains specifications, and all 3 lines have the same product code. How can I remove duplicates and fill in all columns in one product code? For example, so that on line 1 there were both photos and videos and characteristics, on line 2 there was already another product with a different code and all columns were also filled in..

Answer 1

1) Collect all unique keys.
=unique(столбец_с_ключами)
2) For each key - look for characteristics.

=filter(столбец_с_характеристикой;столбец_с_ключами=текущий_ключ)

3) There can be a lot of such lines in paragraph 2, so you need to uniqueize them and write what is left in a cell. Here the formula must be written exactly like this, in two lines

=join("
";unique(filter(столбец_с_характеристикой;столбец_с_ключами=текущий_ключ)))

If you need a ready-made solution - write in a personal

Answer 2

here, apart from writing some kind of script that will collect everything as it should, you can’t think of anything else ...