hey guys, I'm not sure if what I would like to do is possible or not.
Basically, every week I put out a list of every different variation of
product that will be produced over the next eight weeks. The problem I run
into is that over the course or eight weeks, some product variations repeat
numerous times. Right now, I have to manually combine each variation across
the eight weeks via cutting and pasting then deleting the now empty row. Is
there any way to sort the file, then have excel combine the rows and delete
the rows that become empty?

About the file we use:

Rows are as follows:

Production line: Product description: Wk 1 : Wk 2:... Wk 8: Total:

The file is about 500 different variations long.

Thanks for any help you can provide!