Hiow to get all data in one column ?

  • Thread starter Thread starter nitin24dec
  • Start date Start date
N

nitin24dec

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

Thanks/...
 
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...
 
Hi,

Select all the data you want, try [copy] and [paste special], clic
[transpose]. That should do it
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarizing Dates into Months and Years 8
Using a cell reference to create linked info in another cell 2
Problem with if function in excel 4
Keeping the column constant in a formula 4
ignore blank cells in a formula 1
Help with last 7 days running total 11
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Help to copy information from one row at a time to another sheet 1

Back
Top