raaool1701
New Member
- Joined
- Sep 17, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hello,
My data is organized in rows as shown below:
(Sorry about the formatting of the data below)
The same person can be assigned multiple badges. However, the same badge cannot be assigned to more than 1 person.
I would like to convert it to a single row per name/email either with a formula, pivot or some form of automation so that the final product looks something like
Possible? Thanks in advance.
My data is organized in rows as shown below:
(Sorry about the formatting of the data below)
The same person can be assigned multiple badges. However, the same badge cannot be assigned to more than 1 person.
Name | Badge ID | |
a | a1 | 123 |
a | a1 | 234 |
a | a1 | 345 |
b | b1 | 456 |
c | c1 | 567 |
d | d1 | 678 |
d | d1 | 789 |
I would like to convert it to a single row per name/email either with a formula, pivot or some form of automation so that the final product looks something like
Name | Badge ID1 | Badge ID2 | Badge ID3 | |
a | a1 | 123 | 234 | 345 |
b | b1 | 456 | ||
c | c1 | 567 | ||
d | d1 | 678 | 789 |
Possible? Thanks in advance.