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"

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Question ajoutée par Ruma Alleck , Senior Secretary , Le Bocage International School
Date de publication: 2016/01/14

Apprécier (0) Vues (0) Suiveurs (1) Réponses (1) Report Question

par 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 ... Voir Plus

Réponses (3)
You can auto fit the width of column by
Top Answer: C............................................. Voir Plus

Réponses (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 Voir Plus

Réponses (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 ... Voir Plus

Réponses (5)

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?

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?