View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Combining 1 column into many columns

There are several different configurations you could wind up with.

Snaked 1-50 in A then 51-100 in B then 101-150 in C etc. for how many columns?

OR 1-20 across row 1 and 21-40 across row 2

Which do you want?


Gord Dibben MS Excel MVP



On Wed, 4 Oct 2006 10:17:02 -0700, Help @ Work <Help @
wrote:

I am trying to copy data from column A and paste it into many different
columns (B, C, D, E, etc...). Can and how do I do this?