The Great SrH
Board Regular
- Joined
- Jan 16, 2015
- Messages
- 179
Hi all,
I'm really sorry as I'm struggling to even describe what I'm asking help for here.
I basically have a list of 30,000 rows of data where Column C is the unique number relating to a customer and Column D is a product they hold.
I'm looking for some code to do something like run down the list and if Column C exists, move the information into the next available column after Column D.
For the sake of an example, I'm using Column A as the Unique Number and Column B is the product.
Current List:
<tbody>
</tbody>
Desired Output:
<tbody>
</tbody>
I'm really sorry as I'm struggling to even describe what I'm asking help for here.
I basically have a list of 30,000 rows of data where Column C is the unique number relating to a customer and Column D is a product they hold.
I'm looking for some code to do something like run down the list and if Column C exists, move the information into the next available column after Column D.
For the sake of an example, I'm using Column A as the Unique Number and Column B is the product.
Current List:
Row | Column A | Column B |
1 | Unique Number | Product |
2 | 12345 | Banana |
3 | 12345 | Pear |
4 | 7210 | Apple |
5 | 12345 | Apple |
6 | 1234 | Grape |
7 | 7210 | Berry |
8 | 7210 | Melon |
9 | 12345 | Grape |
10 | 12345 | Melon |
11 | 7210 | Banana |
12 | 5065 | Banana |
13 | 5792 | Apple |
14 | 5792 | Pear |
15 | 8090 | Grape |
<tbody>
</tbody>
Desired Output:
Row | Column A | Column B | Column C | Column D | Column E | Column F | Column G |
1 | Unique Number | Product | Product | Product | Product | Product | Product |
2 | 12345 | Banana | Pear | Apple | Grape | Melon | |
3 | 7210 | Apple | Berry | Melon | Banana | ||
4 | 1234 | Grape | |||||
5 | 5065 | Banana | |||||
6 | 5792 | Apple | Pear | ||||
7 | 8090 | Grape |
<tbody>
</tbody>