Minimizing Rows of with similar data

U

urlocaljeweler

I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.
 
L

Lars-Åke Aspelin

I am using Excel 2007.

I have 3 columns A, B, and C such as below:

TU10-10 TU10 Tungsten Satin Wedding Band
TU10-10.5 TU10 Tungsten Satin Wedding Band
TU10-11 TU10 Tungsten Satin Wedding Band
TU10-11.5 TU10 Tungsten Satin Wedding Band
TU10-12 TU10 Tungsten Satin Wedding Band
TU10-12.5 TU10 Tungsten Satin Wedding Band
TU10-13 TU10 Tungsten Satin Wedding Band
TU10-6 TU10 Tungsten Satin Wedding Band
TU10-6.5 TU10 Tungsten Satin Wedding Band
TU10-7 TU10 Tungsten Satin Wedding Band
TU10-7.5 TU10 Tungsten Satin Wedding Band
TU10-8 TU10 Tungsten Satin Wedding Band
TU10-8.5 TU10 Tungsten Satin Wedding Band
TU10-9 TU10 Tungsten Satin Wedding Band
TU10-9.5 TU10 Tungsten Satin Wedding Band
TU12-10 TU12 Tungsten Brushed Wedding Band
TU12-10.5 TU12 Tungsten Brushed Wedding Band
TU12-11 TU12 Tungsten Brushed Wedding Band
TU12-11.5 TU12 Tungsten Brushed Wedding Band
TU12-12 TU12 Tungsten Brushed Wedding Band
TU12-12.5 TU12 Tungsten Brushed Wedding Band
TU12-13 TU12 Tungsten Brushed Wedding Band
TU12-6 TU12 Tungsten Brushed Wedding Band
TU12-6.5 TU12 Tungsten Brushed Wedding Band
TU12-7 TU12 Tungsten Brushed Wedding Band
TU12-7.5 TU12 Tungsten Brushed Wedding Band
TU12-8 TU12 Tungsten Brushed Wedding Band
TU12-8.5 TU12 Tungsten Brushed Wedding Band
TU12-9 TU12 Tungsten Brushed Wedding Band
TU12-9.5 TU12 Tungsten Brushed Wedding Band

I have over 12000 rows with similar data for multiple products. I need to
minimize the rows so that I have only one row for each product(such as one
row for TU10 and one row for TU12) I need only one description(column C) per
item. I do not need column A at all.

For instance, instead of the example above with multiple rows for the 2
products in column B(TU10 and TU12) I need only 2 rows and 2 columns. For
example:

TU10 Tungsten Satin Wedding Band
TU12 Tungsten Brushed Wedding Band

Any thoughts on a formula to accomplish my task?

Thank you.


Select columns B and C, then on the Data tab, in the Data Tools group,
click Remove Duplicates.

Hope this helps / Lars-Åke
 
A

Arceedee

Assuming the tu10 and tu12 are in a separate column then use DATA-DATA
TOOLS-REMOVE DUPLICATES tool.

Delete col a
 
G

Gord Dibben

Select columns A:C

Data>Filter and Sort>Advanced.

List Range A:C

Criteria Range B:B

Filter in place and checkmark "unique records"

If you don't have a title row, you will see two "TU10"'s


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top