Help with merging columns in Excel file

vcharles
vcharles used Ask the Experts™
on
Hi,

How do you merge columns in an excel file?

Victor
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Naresh PatelFinancial Adviser

Commented:
Formula to merge column content.
=A2&B2&C2&D2

So & is combining content of cells if you want to add space between than
=A2&" "&B2&" "&C2

Thanks

Author

Commented:
Thanks, I will try it and get back to you.
Naresh PatelFinancial Adviser

Commented:
Pls see attached for better understanding...


Thanks
Column-Combine.xlsx
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

Author

Commented:
How do I include the formula?
Naresh PatelFinancial Adviser

Commented:
May I have your sample file .... I will do it on your behalf...

Thanks

Author

Commented:
Unfortunately I can't send you the file. Can you please send me some instructions.

I typed the formula in the formula editor but don't know how to execute it to apply to all the rows.

Thanks,

V.
Naresh PatelFinancial Adviser

Commented:
ok then tell me which column you want to combine & do u want spaces between ?

Thanks

Author

Commented:
I want to combine the columns 6 to 11 with no spaces between the data.

Thanks,

V.
Naresh PatelFinancial Adviser

Commented:
ok give me one moment....it means from column F to K without spaces right ? & result in column L right?
Naresh PatelFinancial Adviser

Commented:
Use this in Cell L1 & copy past to lower rows or use drop down.
=F1&G1&H1&I1&J1&K1

Open in new window

Naresh PatelFinancial Adviser

Commented:
if there is header in Row 1 then put this formula in cell L2 & just copy past or dropdown
=F2&G2&H2&I2&J2&K2

Open in new window

=F1&G1&H1&I1&J1&K1

Open in new window

Naresh PatelFinancial Adviser

Commented:
if there is header in Row 1 then past this formula in L2 & copy past or drop down in lower rows.

Thanks
=F2&G2&H2&I2&J2&K2

Open in new window

Financial Adviser
Commented:
This is sample just see how it is works.

Thanks
Column-Combine.xlsx

Author

Commented:
I have headers in all the columns, heading to the office will get back to you within the hour.

Thanks.

V.
Naresh PatelFinancial Adviser

Commented:
ok & I am heading towards Home  :)


Thanks
Naresh PatelFinancial Adviser

Commented:
If you tell me how exactly final result you wants then I will guide you properly.
1.want to combine column value as it is.
2.Combine and delete combined columns and need final only one column.

Thanks

Author

Commented:
Hi,

I need to understand your previous posts and try again, will get back to you.

Thank You.

Victor
Naresh PatelFinancial Adviser

Commented:
Tell me what you dint understand I will post screen shots of every steps.

Thanks

Author

Commented:
Hi,

I'm sorry for the late reply. I figured it out.

Thank You.

Victor
Naresh PatelFinancial Adviser

Commented:
Glade to help you ...


Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial