Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving data from multiple cells to one column
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Column charts with multiple data in each column | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |