As an organisation, Mixd is always keen to help others… and today is no exception. Based on the results of important scientific research (Bob closely watching Phil this morning and chuckling), this could save you from days of stress and sleepless nights of worry.
So here it is, the simple process of merging 2 (two) columns of data into 1 (one) using the Microsoft product ‘Excel’. Step one can be omitted as you see fit, but can be fun.
Step One
Watch colleague pull own hair out for up to 90 minutes (longer than this is just not on), trying to work out how to do it.
Step Two
Assuming the data to be merged sits in columns A and B, select column C and choose Insert > Column to insert a new (blank) column C.
Step Three
Assuming that data starts in row 2 (allowing for your headings), whack one of the following formulae into cell C2.
To hyphenate the merged data
=A2&”-”&B2
To merge with a space between the data
=A2&” “&B2
Step Four
Copy the formula as far down column C as needed (by dragging the bottom right corner of the C2 cell).
Step Five (the magic bit!)
Next, select the entire column C; choose Edit > Copy; then Edit > Paste Special; then Values and OK. This pastes the cell contents (not the formulae) back into column C.
Step Six
You can now simply delete columns A and B; easy.
Please send thank you cards to the usual address.
Mixd accepts no liability if this doesn’t work for you; apologies.
