Hi
On Sheet1, I have the following columns of data
<tbody>
</tbody>
On Sheet2, I have the desired output shown below.
I have already created VBA that copies the B column from Sheet1 to Sheet2 and then removes duplicates to create a unique list of numbers. I then have a VLOOKUP set up to capture the name associated with the number. My problem is Column C on Sheet2.
I want to combine all of the Types from each customer, removing any duplicate entries.
The desired output is below and you can cross-reference this to Sheet1
<tbody>
</tbody>
Is there a formula that can achieve this? I'm sure there probably is but my knowledge of Excel formulas isn't amazing.
Thanks
On Sheet1, I have the following columns of data
A | B | C | D | |
1 | DATE | NUMBER | NAME | TYPE(S) |
2 | 01/01/2019 | 123 | J Bloggs | A,B |
3 | 01/01/2019 | 456 | D Smith | A |
4 | 01/01/2019 | 789 | P Jones | B,C |
5 | 02/01/2019 | 123 | J Bloggs | B |
6 | 02/01/2019 | 789 | P Jones | D |
7 | 03/01/2019 | 456 | D Smith | A,B,C |
8 | 03/01/2019 | 789 | P Jones | C |
9 | 03/01/2019 | 000 | J Doe | A |
10 | 03/01/2019 | 123 | J Bloggs | A,C |
11 | 04/01/2019 | 456 | D Smith | A |
12 | 05/01/2019 | 123 | J Bloggs | A,B |
13 | 05/01/2019 | 456 | D Smith | B,D |
<tbody>
</tbody>
On Sheet2, I have the desired output shown below.
I have already created VBA that copies the B column from Sheet1 to Sheet2 and then removes duplicates to create a unique list of numbers. I then have a VLOOKUP set up to capture the name associated with the number. My problem is Column C on Sheet2.
I want to combine all of the Types from each customer, removing any duplicate entries.
The desired output is below and you can cross-reference this to Sheet1
A | B | C | |
1 | NUMBER | NAME | TYPE(S) |
2 | 123 | J Bloggs | A,B,C |
3 | 456 | D Smith | A,B,C,D |
4 | 789 | P Jones | B,C,D |
5 | 000 | J Doe | A |
<tbody>
</tbody>
Is there a formula that can achieve this? I'm sure there probably is but my knowledge of Excel formulas isn't amazing.
Thanks