Solved

Help with merging columns in Excel file

Posted on 2014-02-27
20
141 Views
Last Modified: 2014-03-02
Hi,

How do you merge columns in an excel file?

Victor
0
Comment
Question by:vcharles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 13
  • 7
20 Comments
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39893817
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
 

Author Comment

by:vcharles
ID: 39893880
Thanks, I will try it and get back to you.
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894385
Pls see attached for better understanding...


Thanks
Column-Combine.xlsx
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

Author Comment

by:vcharles
ID: 39894507
How do I include the formula?
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894512
May I have your sample file .... I will do it on your behalf...

Thanks
0
 

Author Comment

by:vcharles
ID: 39894541
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
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894543
ok then tell me which column you want to combine & do u want spaces between ?

Thanks
0
 

Author Comment

by:vcharles
ID: 39894550
I want to combine the columns 6 to 11 with no spaces between the data.

Thanks,

V.
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894552
ok give me one moment....it means from column F to K without spaces right ? & result in column L right?
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894558
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
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894560
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
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894561
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
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 500 total points
ID: 39894571
This is sample just see how it is works.

Thanks
Column-Combine.xlsx
0
 

Author Comment

by:vcharles
ID: 39894576
I have headers in all the columns, heading to the office will get back to you within the hour.

Thanks.

V.
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894590
ok & I am heading towards Home  :)


Thanks
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39894743
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
 

Author Comment

by:vcharles
ID: 39894897
Hi,

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

Thank You.

Victor
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39899555
Tell me what you dint understand I will post screen shots of every steps.

Thanks
0
 

Author Comment

by:vcharles
ID: 39899574
Hi,

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

Thank You.

Victor
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39899586
Glade to help you ...


Thanks
0

Featured Post

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question