Concatenate Existing Columns
I have an existing sheet with hundreds of lines of data. We recently decided we needed to combine two of the columns, but don't want to have to go through each line and combine them. Is there a formula I can use to copy the information from Column B into Column A with a space and comma in between?
If I use =JOIN(ColumnA:ColumnB," ") it adds everything selected into one cell. I need to differentiate between rows without having to set up an equation for each row.
Help Article Resources
Check out the Formula Handbook template!