How to automate the process of changing a table in excel?

Question

excel

I make a 1C file from the uploads, for importing into the Internet Store.
There is such a table:
You need to do this: while the product code (column 1) is equal to one number, you need to combine all the modified prices (column 4) into one line.
Etc. Each time the product code becomes a different number, a new long line should appear.
How can this be done, and with what? Thank you.

Answer 1

I found the solution here: www.planetaexcel.ru/forum/index.php?PAGE_NAME=read...