Transpose data

[raaool1701]

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.

Name	Email	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	Email	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.

 

[Fluff]

Glad we could help & thanks for the feedback.