Create Single row from multiple rows

[georgechacko]

Hi,

Looking for an Alteryx workflow for the below case

input sheet content

Field1       Field2     Field3    Field4

AAA          abc      

AAA                         efg

AAA                                      xyz

output

Field1       Field2     Field3    Field4

AAA          abc          efg        xyz                                       

Request a work flow to create this output. 

Thanks in Advance,

George

[binuacs · Accepted solution]

@georgechacko One way of dong this with the help of summarize tool

[binuacs · Accepted solution]

@georgechacko Another way of dong this with the help of Transpose and Cross Tab tool

[georgechacko]

Hi Binuacs,

Thanks for the solution. working as expected...

Regards,

George