| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help with transferring data in one column to multiple columns.
I have a list of data that ranges from one cell in column A to over 400 cells
(this can change as well) in column A. At the moment I have to manually cut and paste the first 50 cell from column A to Column B, then manually cut and paste the next 50 from column A to column C, then the next 50 into column D and so on. The above should be flexible where I can vary the number of cells to be cut and pasted. Is there a way that the above can be automated? Any help offered would be appreciated. -- Thank U and Regards Ann |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
| transferring data between multiple documents | Excel Discussion (Misc queries) | |||
| how to setup transferring data from row to column | Setting up and Configuration of Excel | |||
| How to setup transferring data from row to column? | Excel Discussion (Misc queries) | |||
| splitting 1 column of data into multiple columns | Setting up and Configuration of Excel | |||
Threaded Mode
