If I have a list that has a row for every product an employee has, how can I convert that to one per emloyee and there are multiple columns that contain their products.
Example
1234 Prod1
1234 Prod2
1234 Prod3
1235 Prod1
1235 Prod2
1235 Prod3
1236 Prod1
1236 Prod2
Convert to:
1234 Prod1 Prod2 Prod3
1235 Prod1 Prod2 Prod3
1236 Prod1 Prod2
Paste Special works, but only if I manually select one group of rows for the same emloyee. Is there a formula or macro I can do for this?
Thanks!!!!
Russ
Example
1234 Prod1
1234 Prod2
1234 Prod3
1235 Prod1
1235 Prod2
1235 Prod3
1236 Prod1
1236 Prod2
Convert to:
1234 Prod1 Prod2 Prod3
1235 Prod1 Prod2 Prod3
1236 Prod1 Prod2
Paste Special works, but only if I manually select one group of rows for the same emloyee. Is there a formula or macro I can do for this?
Thanks!!!!
Russ