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

Hi @spdhg,

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

Result:

transpose_concat.yxmd