| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move data from one line to another
I have two stores. I have a spreadsheet generated by company software that
shows inventory at both stores, but on separate lines. For example: Store Item Qty Qty Store 2 1 A 4 ? 2 A 6 I want to move the 6 from the second line to the ? on the first line. I can then sort by Store and delete all records from Store 2 and end up with: Store Item Qty Qty Store 2 1 A 4 6 Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I move data to a new line in a cell after a comma? | Excel Worksheet Functions | |||
| Move data line from end of page 1 to page 2 | Charts and Charting in Excel | |||
| If a criteria isn't met, move to the next line.... | Excel Discussion (Misc queries) | |||
| Line and text box move by themselves | Charts and Charting in Excel | |||
| Move equations from line to line automatically | Excel Discussion (Misc queries) | |||
Threaded Mode
