View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default transfer data from one column into another column

InsertColumns wherever you wish.

i.e. select column C & D and InsertColumns to get two blank columns.


Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 10:36:03 -0800, Wessel
wrote:

Thanks for your replys guys, I guess I should make myself more clear. What I
am trying to do is as follows: I have been letting each column represent a
day, and each cell a task I have been doing. So now I have about 10 columns
filled in. But to make the sheet more presentable, I want to insert blank
columns for Saturday and Sunday. (I don't work then!) So, how do I go back
and insert blank columns? Because, if I use the cut/copy&paste option, surely
I would just be dumping the data from one column onto another one? Unless, I
suppose, I start from the last column, which has nothing to the right of it,
cut and paste that a few places to the right, and then, working my way from
right to left, move each column a few spots to the right, until I have some
empty columns in the middle representing Sat + Sun. But is there a more
efficient way? My eventual goal is to be able to make the computer do
whatever I want simply by snapping my fingers at it, so getting advice from
you guys is a first step in that direction.
"Ray A" wrote:

Several ways come to mind.
1)copy and paste
2)insert a new column A
3) in B1 enter =A1 and copy down
I am not sure what you are trying to accomplish



"Wessel" wrote:

How would you transfer all your data from one column into another column? Eg
from Column A to column B?