Hi there, I have some data for 10000 cases in 10000 raws in Excel RANGED from Column A to S. I want all the raws transposed and been copied in the same column i.e., column T. I have tried Macros but it does not go beyond the first two raws. Any advice is appreciated.You have a very large number of rows and I do not know whether that will prevent the procedure for  this from working.  But, try the procedure as explained at http://office.microsoft.com/en-us/excel-help/switch-transpose-columns-and-rows-HP010224502.aspxThanks BUT I think this is not what I am looking for.
I  give you an example . Suppose that the FOLLOWINGS are the first two rows of data:

The data in columns A to H were as follow:
1   Cardiff   London         Manchester  LEEDS      Swansea   Chester      Liverpool   Glasgow
2   London  Manchester  Leeds          Swansea  Chester     Liverpool    Glasgow    Sheffield

What I want is not a simple transpose but I want transpose the first ROW in a new column e.g., I and then transpose the second row in the same column i.e. column I, immediately after the transposed data of the first row. Therefore the final output will be like this:
1
Cardiff   
London       
Manchester 
Leeds     
Swansea 
Chester     
Liverpool   
Glasgow
2   
London 
Manchester
Leeds         
Swansea 
Chester     
Liverpool   
Glasgow   
Sheffield

I am sure you would ask why I can not doing that as above simply by TRANSPOSING the rows, one by one in the same column. Well, this is because the number of rows are more than 100000, therefore I need a Macro.
Thanks in advance,
Masoud