I was wondering if there was an easier way to Transpose Text from column to Rows, other than copying the cells then right clicking, special paste then selecting transpose. I have to do this about 1000 times and i would like to see if there is an easy macro that might do it for me. any help would be appreciated.


Thanks in Advanced,
Joe