Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

On a spreadsheet, how to get data from 3 columns into 1 column - eg, you have 3 columns with "1st name", "2nd name" and "Surname" - change to 1 column?

Data Quality
user-image
Question added by Ruma Alleck , Senior Secretary , Le Bocage International School
Date Posted: 2016/01/14
Upvote (0) Views (0) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Shyra Love Serapio
by Shyra Love Serapio , HR Business Partner , Metropolitan Bank and Trust Company

Hi Ruma, you have to use the formula concatenate to combine together3 columns to1.

Write Your Answer
More Questions Like This