Group By Value then move values to new columns

[spdhg]

Apologies if this has been asked before/seems simple but for some reason I can't find a solution.

See before and after for what I'd like my data to look like:

Before:

Acct	Email
1234	xyzxyz
1234	abcabc
1234	asdasd
5678	tyui
5678	qwer

After:

Acct	Email_1	Email_2	Email_3
1234	xyzxyz	abcabc	asdasd
5678	tyui	qwer	[null]

Is there a simple workflow/tool to do this that can also automatically add and name columns?

Thanks!

[ggruccio · Accepted solution]

Hi @spdhg,

It should work with a transpose then concatenate with a bit of logic built in between.  See example below..

Result:

[spdhg]

That is both an elegant solution to the problem as well as a surprising revelation that a simpler tool wasn't available!

Either way solved the issue exactly as expected so thank you!