jmattingly85
New Member
- Joined
- Jul 12, 2010
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
I am needing some assistance with VLOOKUP, and that might not even be what I need to use. I have an Excel spreadsheet of data that currently looks as follows:
<tbody>
</tbody>
What I need to is get all of the data in Column B to be in columns D, E and F by their code description as follows:
<tbody>
</tbody>
Is this possible to do fairly easy?
A | B | C |
Name | Code | Amount |
NAME A | code 1 | 12 |
NAME A | code 2 | 13 |
NAME A | code 3 | 81 |
NAME B | code 3 | 56 |
NAME B | code 2 | 98 |
NAME C | code 2 | 67 |
NAME C | code 3 | 56 |
NAME C | code 1 | 12 |
<tbody>
</tbody>
What I need to is get all of the data in Column B to be in columns D, E and F by their code description as follows:
A | B | C | D | E | F |
Name | Code | Amount | Code 1 | Code 2 | Code 3 |
NAME A | 12 | 14 | 81 | ||
NAME B | 98 | 56 | |||
NAME C | 12 | 67 | 56 |
<tbody>
</tbody>
Is this possible to do fairly easy?