A | B
-----
1 | a
2 | b
3 | c
and I'd like to have a third column that merges the data like this:
A | B |
---------
1 | 1, a
2 | 2, b
3 | 3, c
currently I can kind of do this one row at a time in a column C with this formula:
= A:A1&", "&B:B1
How can it be done to the entire column B?