Merging multiple columns into one single column


G

Guest

I am trying to take multiple columns and merge that data into one column and cannot seem to find an answer. For example. I have a tree type structure in columns A, B, C, and D:

Corporate (Column A)
Product Sales (Column B)
Sales Rep 1 (Column C)
Hardware (Column D)
Software (Column D)
Services (Column D)

I then want the date to be down one column:

(All Column A)
Corporate
Product Sales
Sales Rep 1
Hardware
Software
Services

Is this possible in Excel? Any help anyone could give would be deeply appreciated.
 
Ad

Advertisements

C

charlieo

First insert a new column 'A'

In cell A1 type "=B1"
In cell A2 type "=C2"
In cell A3 type "=D3"
In cell A4 type "=E4"
In cell A5 type "=E5"
In cell A6 type "=E6"

Select cell A1.A6 and use the copy command.
Leaving the cell pointer in A1 use paste special and check
Values only.
You will now have the proper Rows labeled as text.
Delete the text in B1, C2, D3, E4, E5 and E6.
Depending if there is date in the adjacent cells (columns)
you may need to insert additional
Columns to equal the number of cells (columns) containing
data. Use the same sequence
As above and replicate it across the required columns.
Highlight all the cells containing the new data and again
use copy and paste special Values.
Delete the old data and there you are.

It look like a lot of work but once you get stated it's
not so bad.

Of course you could build a new workbook.
-----Original Message-----
I am trying to take multiple columns and merge that data
into one column and cannot seem to find an answer. For
example. I have a tree type structure in columns A, B, C,
and D:
 
K

Ken Wright

Sure, as long as the cells that look blank are really blank. Assuming your data
is in Cols A,B,C,D, select A1:Dxx and do Edit / Go To / Special Cells / Blanks,
then do Edit / Delete / Shift cells Left.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



KevinT said:
I am trying to take multiple columns and merge that data into one column and
cannot seem to find an answer. For example. I have a tree type structure in
columns A, B, C, and D:
 
G

Guest

Thanks to everyone who responded. Ken's choice seem to work the best and easiest. I appreciate the responses.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top