Help with merging columns in Excel file

Hi,

How do you merge columns in an excel file?

Victor
vcharlesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Naresh PatelFinancial AdviserCommented:
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
0
vcharlesAuthor Commented:
Thanks, I will try it and get back to you.
0
Naresh PatelFinancial AdviserCommented:
Pls see attached for better understanding...


Thanks
Column-Combine.xlsx
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

vcharlesAuthor Commented:
How do I include the formula?
0
Naresh PatelFinancial AdviserCommented:
May I have your sample file .... I will do it on your behalf...

Thanks
0
vcharlesAuthor 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.
0
Naresh PatelFinancial AdviserCommented:
ok then tell me which column you want to combine & do u want spaces between ?

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

Thanks,

V.
0
Naresh PatelFinancial AdviserCommented:
ok give me one moment....it means from column F to K without spaces right ? & result in column L right?
0
Naresh PatelFinancial AdviserCommented:
Use this in Cell L1 & copy past to lower rows or use drop down.
=F1&G1&H1&I1&J1&K1

Open in new window

0
Naresh PatelFinancial AdviserCommented:
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

0
Naresh PatelFinancial AdviserCommented:
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

0
Naresh PatelFinancial AdviserCommented:
This is sample just see how it is works.

Thanks
Column-Combine.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vcharlesAuthor Commented:
I have headers in all the columns, heading to the office will get back to you within the hour.

Thanks.

V.
0
Naresh PatelFinancial AdviserCommented:
ok & I am heading towards Home  :)


Thanks
0
Naresh PatelFinancial AdviserCommented:
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
0
vcharlesAuthor Commented:
Hi,

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

Thank You.

Victor
0
Naresh PatelFinancial AdviserCommented:
Tell me what you dint understand I will post screen shots of every steps.

Thanks
0
vcharlesAuthor Commented:
Hi,

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

Thank You.

Victor
0
Naresh PatelFinancial AdviserCommented:
Glade to help you ...


Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.