Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Help with merging columns in Excel file

Hi,

How do you merge columns in an excel file?

Victor
0
vcharles
Asked:
vcharles
  • 13
  • 7
1 Solution
 
Naresh PatelTraderCommented:
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 PatelTraderCommented:
Pls see attached for better understanding...


Thanks
Column-Combine.xlsx
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
vcharlesAuthor Commented:
How do I include the formula?
0
 
Naresh PatelTraderCommented:
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 PatelTraderCommented:
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 PatelTraderCommented:
ok give me one moment....it means from column F to K without spaces right ? & result in column L right?
0
 
Naresh PatelTraderCommented:
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 PatelTraderCommented:
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 PatelTraderCommented:
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 PatelTraderCommented:
This is sample just see how it is works.

Thanks
Column-Combine.xlsx
0
 
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 PatelTraderCommented:
ok & I am heading towards Home  :)


Thanks
0
 
Naresh PatelTraderCommented:
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 PatelTraderCommented:
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 PatelTraderCommented:
Glade to help you ...


Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 13
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now