Moving data from multiple cells to one column

Giganews Newsgroups
Subject: Moving data from multiple cells to one column
Posted by:  builder.reload…@gmail.com
Date: 27 Jun 2006

We are currently running an audit of a rather large network, and we
determined that the best way to list the data output would be in an
excel spreadsheet. However, we would like to organize the data by
giving certain types of entries their own columns while remaining in
the same row. I've searched high and low for a method to move data from
single cells in different columns into a single column in one fell
swoop, but have come up short.

x = data of interest
- = other data

What it's like now:
x  -  -  -  -  -  -  -
-  -  -  x  -  -  -  -
-  -  -  -  -  -  -  x

The way we need it to be:
x  -  -  -  -  -  -  -
x  -  -  -  -  -  -  -
x  -  -  -  -  -  -  -

Has anyone been able to do this in Excel?

Replies