| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase rows by 1 when moving data from col. to col.
Is there a way to move data from one column to another and have it
automatically update the row number by 1? Example: Move Col-A to Col-D row 1 = BW1 row 1 = BW2 row 2 = BW43 row 2 = BW44 row 3 = BW85 row 3 = BW86 row 4 = BW127 row 4 = BW128 I'm not good at explaining what I want to do, so hopefully the example helps. And it will certainly speed up the process as I'm now having to manually change line by line and there are MANY lines. -- Gayle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
| Moving data from multiple rows into a single row | Excel Discussion (Misc queries) | |||
| Moving data in rows to columnar | Excel Discussion (Misc queries) | |||
| moving column/cell data to rows/cells fails | Excel Worksheet Functions | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
Threaded Mode
