(I'm re-posting this question under a separate title).
I have 160,000 rows of sales info, so it's not uncommon to have an SKU # listed thousands of times because the sales info is for every sale made over the last 6 years.
My goal is to get a shorter list of all the SKUs--just once, but with other columns of info related to the SKU # column. One issue is that a SKU # might describe several different variations of the same product family. For instance, SKU #100, describes a "Plain nut," a "Plain nut-red," and a "Plain nut-green." (see example below). If I use the Advance Filter command under "Data" ("Copy unique records only"), it will return the Product SKU 3x, when I only want it to be returned once. Any suggestions? Thanks again.
Product SKU Product Line Name Other Descrip Product Description
100 Nut Nut Plain nut
100 Nut Nut Plain nut-red
100 Nut Nut Plain nut-green
I have 160,000 rows of sales info, so it's not uncommon to have an SKU # listed thousands of times because the sales info is for every sale made over the last 6 years.
My goal is to get a shorter list of all the SKUs--just once, but with other columns of info related to the SKU # column. One issue is that a SKU # might describe several different variations of the same product family. For instance, SKU #100, describes a "Plain nut," a "Plain nut-red," and a "Plain nut-green." (see example below). If I use the Advance Filter command under "Data" ("Copy unique records only"), it will return the Product SKU 3x, when I only want it to be returned once. Any suggestions? Thanks again.
Product SKU Product Line Name Other Descrip Product Description
100 Nut Nut Plain nut
100 Nut Nut Plain nut-red
100 Nut Nut Plain nut-green
