Thanks for your response. I have tried the Transpose feature but that just turns the whole range thru 90 degrees. This is not what i am trying to do. I need to transpose and realign the data vertically above each other as well as create additional space vertically for the name range which should remain in Col A, as in my example. I really need to find a way to reformat data in a report in the way I describe. I have tried for some time to do this but it's got me beat so far. Any ideas would be great.