Create Single row from multiple rows

Question

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

binu_acs · Accepted Answer

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

binu_acs · Accepted Answer

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