|
Minimizing Rows of with similar data
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. |
Minimizing Rows of with similar data
On Wed, 9 Dec 2009 08:13:03 -0800, urlocaljeweler
wrote: 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 |
Minimizing Rows of with similar data
Assuming the tu10 and tu12 are in a separate column then use DATA-DATA
TOOLS-REMOVE DUPLICATES tool. Delete col a "urlocaljeweler" wrote: 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. |
Minimizing Rows of with similar data
Select columns A:C
DataFilter and SortAdvanced. 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 On Wed, 9 Dec 2009 08:13:03 -0800, urlocaljeweler wrote: 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. |
| All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com