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?