• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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