Excel - Combine multiple columns into one column

0 votes

I have multiple lists that are in separate columns in excel. What I need to do is combine these columns of data into one big column. I do not care if there are duplicate entries, however I want it to skip row 1 of each column.

Also what about if ROW1 has headers from January to December, and the length of the columns are different and needs to be combine into one big column?

ROW1| 1   2   3    
ROW2| A   D   G    
ROW3| B   E   H    
ROW4| C   F   I

should combine into

A    
B    
C    
D    
E    
F    
G    
H    
I

The first row of each column needs to be skipped.

Mar 25 in Database by Edureka
• 9,320 points
27 views

1 answer to this question.

0 votes
In Excel, how can I concatenate (combine) many columns into one field?
In column D, use the CONCATENATE function: =CONCATENATE (A1,B1,C1).
Select Insert, Function from the menu bar.
Fill in the text1 field with A1, the text2 field with B1, and the text3 field with C1.
Click the OK button.
Copy and paste as many records as you require.
answered Mar 30 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

answered Apr 4 in Database by Edureka
• 9,320 points
75 views
0 votes
1 answer

What to combine two tables into one.

Hii Nikola, I think you need to UNION ALL otherwise you ...READ MORE

answered May 21, 2020 in Database by Niroj
• 82,680 points
273 views
0 votes
1 answer

Excel COUNTIF with multiple criteria and both row and column

Count Cells Based On Text Value Using ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
26 views
0 votes
1 answer

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

If anyone needs to do this in ...READ MORE

answered Mar 30 in Database by Edureka
• 8,820 points
24 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4 in Database by Edureka
• 9,320 points
31 views
+1 vote
1 answer

How to migrate a PostgreSQL database into a SQLServer one?

Hello @kartik, The easier way to accomplish this. First ...READ MORE

answered May 13, 2020 in Database by Niroj
• 82,680 points
227 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer
0 votes
1 answer

Merge multiple Excel sheets into one sheet

Merging Excel Sheets: A Step-by-Step Guide Make sure ...READ MORE

answered Apr 4 in Database by Edureka
• 8,820 points
93 views
0 votes
1 answer

Split timestamp column into separate date and time columns in excel

Kutools for Excel allows you to split ...READ MORE

answered Apr 11 in Database by Edureka
• 8,820 points
54 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP