Have file with three columns need some help. The attached file is a sample
Column A is the base or main
In column A there are duplicates numbers however in Column B or C there may be data I want to consolidate
Customer A Customer B Customer C
10-1077S FRC4122
10-1092S FRC4098
10-1093S
10-1094S FRC5278
10-1095S FRC5277
10-11000 RC4085 16-4095
10-11000
10-11001 RC4086 16-4096
10-11001
10-11004 RC4147
10-11004 16-4015
10-11004
10-11005 RC4148 16-4014
10-11005
I am looking to consolidate the number is duplicate twice or three times consolidate to one line. Below is a sample of what I am looking for
Customer A Customer B Customer C
10-1077S FRC4122
10-1092S FRC4098
10-1093S
10-1094S FRC5278
10-1095S FRC5277
10-11000 RC4085 16-4095
10-11001 RC4086 16-4096
10-11004 RC4147 16-4015
10-11005 RC4148 16-4014
10-11006
Bookmarks