Hi.
I currently have a large table of data in an Excel spreadsheet that spreads between the range C4:FZ23.
On another page, I want to list all the data in the table in a single column. For example, in the range B3:B600. It does not matter what order the data is in when put into the column, I just need it all to be there!
How can I do this without having to copy, paste and drag every row? This isn't an option due to the time it would take with the sheer amount of data in the table.
Thanks for much in advance to anybody who replies.
Regards,
Dan
Last edited by shad1var; 11-23-2011 at 10:57 AM.
If there are blanks, then that makes VBA a better solution. If not, you can use =INDEX(Sheet2!$C$4:$FZ$23,MOD(ROW()-3,20)+1,INT((ROW()-3)/20)+1), dragged down as needed. It will take all of column C, then go to D, and so on.
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
Thanks very much for your reply, darkyam.
I now have this working perfectly, thanks very much, appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks