Hello there,

I recently download stock market data from datastream, there are so many wide columns all with similar variable names. My variables are 10 in total. o what i want to do is to copy all the columns in my works sheet into these labelled variable columns. This i show it looks like....For each 10 columns...there is data for a company ....so the other columns have the same data going on to the width....so what i want to do is to have the first 10 columns and then the rest STACKED right under the first ten labelled variable columns. Is the a function, code..i could use. I will be grateful for whoever helps. i have posted a snap shot for you review.Click image for larger version. 

Name:	Multiple columns.jpg 
Views:	14 
Size:	111.3 KB 
ID:	3273