Merging multiple columns into one single column

Giganews Newsgroups
Subject: Merging multiple columns into one single column
Posted by:  KevinT
Date: Mon, 27 Oct 2003

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.

Replies