Merging multiple columns into one single column

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Click to expand...
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:
 
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
Click to expand...
cannot seem to find an answer. For example. I have a tree type structure in
columns A, B, C, and D:
 
Thanks to everyone who responded. Ken's choice seem to work the best and easiest. I appreciate the responses.
 
Back
Top