Merge Columns into One Cell and Keep All Data as Embedded Newlines

[gaoa]

Hello Community:

I recently learned how to merge columns of data into one cell without losing data in Excel. But I wonder how to do it in Alteryx. Thank you in advance for your answers or ideas.

Example:

Input:

Last sign in	Status
1/23/2018	Active
2/11/2019	Active
6/8/2022	Active
6/8/2022	Active
7/24/2019	Active
9/19/2018	Inactive
11/27/2018	Inactive
6/18/2020	Active
7/10/2020	Active
1/16/2020	Active
7/30/2019	Active
4/4/2022	Active
3/2/2023	Active

Output:

Last sign in Status
1/23/2018 Active
2/11/2019 Active
6/8/2022 Active
6/8/2022 Active
7/24/2019 Active
9/19/2018 Inactive
11/27/2018 Inactive
6/18/2020 Active
7/10/2020 Active
1/16/2020 Active
7/30/2019 Active
4/4/2022 Active
3/2/2023 Active

[Yoshiro_Fujimori]

If both fields are in String type, you can just use "+" operator in Formula tool.

[Last sign in ] + " " + [Status]

[binuacs · Accepted solution]

@gaoa You want to merge all the records into one column as @Yoshiro_Fujimori mentioned append the fields into one then use the summarize tool to concatenate with \n delimeter

[Yoshiro_Fujimori]

@binuacs Thank you for the follow up.

I did not fully understand the question of @gaoa, 

as usually I do not think of putting everything into one cell...