Need suggestions on how to merge rows with same values in Alteryx

[Nazwa]

Hi Everyone,

Could anyone give me suggestions on how to merge 2 or more cells/ rows with same value in a clumn, just like the excel function "Merge and Center"? I would like to merge all cells of column A with same values, but column B will remain as is, basically an Alteryx alternative to Excel's "Merge and Center" tool. Would really appreciate your help

Column A	Column B
5/12/2021	Apple
5/12/2021	Banana
5/12/2021	Apple
5/13/2021	Orange
5/13/2021	Orange
5/13/2021	Orange

[Christina_H]

Assuming this is a requirement for an output, the best way I know is to use nested tables to create the merged cells.  Create a table of just your fruits grouped by date, then a second table showing both date and the previous table.

[HomesickSurfer]

Hi @Nazwa 

Consider use of the Summary tool with ColumnA grouped, and; ColumnB concatenated with a newline separator.

If this works for you, please Like, Share and/or Accept as Solution.  Thx.

[Nazwa]

Thanks @ Christina_H for the solution. I actually wanted an alternative to the Table tool as I need to export the output to an excel that would have the Date column with merged cell (similar to the one in the question). Do you have any suggestions for achieving that? Really appreciate your help!

[Nazwa]

Thanks @ HomesickSurfer for the solution. But I had some more numeric columns after the Fruits column, which has now lost it's fruit wise segregation. Is there a way to only merge the Date column and keep all the other columns segregated in rows/unmerged, like the example in the question? Thanks again for your help!

[Christina_H]

@Nazwa if you render the nested tables into Excel it does actually come out with merged cells. You might have trouble getting the headings to come out correctly though. I totally understand if it isn't the right solution for you!