I'm looking for a more efficient way of combining possible duplicate rows depending on the column "Product." Some rows will not have duplicates. Here is a sample of the data I'm working with. In reality, I am working with thousands of these rows and over 40 columns
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
After combining the duplicate rows (using Product), I would achieve something like this:
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Any ideas on how I could make this process more efficient. I am currently doing this manually and it is very painful. Thanks!
Product | Store A | Store B | Store C | |
KOMBUCHA VANILLA | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | |
KOMBUCHA RED | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | |
YOGURT DRINK | 5.99 (4.79 SAL) | |||
YOGURT DRINK | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | ||
YOGURT BANANA 4PK | 5.99 (4.79 SAL) | |||
YOGURT BANANA 4PK | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | ||
YOGURT BERRY 4PK | 5.99 (4.79 SAL) | |||
COFFEE | 3.99 (3.39 SAL) | 3.99 (3.39 SAL) | 3.99 (3.39 SAL) |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
After combining the duplicate rows (using Product), I would achieve something like this:
Product | Store A | Store B | Store C | |
KOMBUCHA VANILLA | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | |
KOMBUCHA RED | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | 3.99 (2.99 SAL) | |
YOGURT DRINK | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | |
YOGURT BANANA 4PK | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | 5.99 (4.79 SAL) | |
COFFEE | 3.99 (3.39 SAL) | 3.99 (3.39 SAL) | 3.99 (3.39 SAL) |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Any ideas on how I could make this process more efficient. I am currently doing this manually and it is very painful. Thanks!