Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving scattered cell data to new column?
What I have is scattered data fields on a worksheet that are not organized
into one column. There is one common entry into every field but the rest of the information is in numbers. Example: "PIN 012345" (Pin is in every cell, but the numbers in every cell are not the same). I want to move all found PIN data to a new column. Example: Cell rows 1 thru 40,000 all have the PIN entry, but in different columns. I need to "Shift/Move" all the PIN data to a new column (without multiple commands for each individual row of data). Help anyone :-( -- LarryW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to total scattered data? | Excel Discussion (Misc queries) | |||
XL 2007 : Cant move data values (scattered points) in XY Scatter c | Setting up and Configuration of Excel | |||
moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
time scale-x with scattered data-y | Charts and Charting in Excel | |||
moving data within a column | Excel Worksheet Functions |