Hiow to get all data in one column ?

N

nitin24dec

I have data in 248 columns in excel, want to come in one comlumn, on
below the other. is it possible ?

Thanks/...
 
J

Jules

You'll need some VB Code for this. If you are mildly
confident in VB then I suggest going to the 'programming'
excel newsgroup, otherwise it is difficult...
 
J

jjj

Hi,

Select all the data you want, try [copy] and [paste special], clic
[transpose]. That should do it
 
Top