Forum Discussion
Merging of rows by blanks in first column
Hi,
If I've understood correctly, you'd like to concatenate the strings in your second column, grouped by the string in your first column.
To do that:
1. Right click first column > fill > down2. Right click first column > group by. Complete group by box as per below:
3. Add custom column > [AllData][second column]
4. Select to Extract Values
5. Add a delimitter of your choice
Hi,
If I've understood correctly, you'd like to concatenate the strings in your second column, grouped by the string in your first column.
To do that:
1. Right click first column > fill > down
2. Right click first column > group by. Complete group by box as per below:
3. Add custom column > [AllData][second column]
4. Select to Extract Values
5. Add a delimitter of your choice
Super! This is great solution! Thank you very much! Really appreciated! 🤝