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

Question

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 AColumn B5/12/2021Apple5/12/2021Banana5/12/2021Apple5/13/2021Orange5/13/2021Orange5/13/2021Orange

Christina_H · Answer

@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!

Nazwa · Answer

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!

Nazwa · Answer

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!