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"

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

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.

Select on the basis of DAY component in datatime column. How can I improve the performance?
Top Answer: First of all, I'd recommend using the ISO-8601 standard format for date/time - it works regardless of the ... See More

Answers (3)
You can auto fit the width of column by
Top Answer: C............................................. See More

Answers (3)
When a row of data is to be converted into columns
Top Answer: Right clik Copy then right click and choose transpose the fourth option under paste See More

Answers (7)
How many Columns Does a "Journal" have?
Top Answer: 5. You can use as many columns as you like. A Journal supports recording of transactions and a business ... See More

Answers (5)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

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?