How do you flip columns in a worksheet in Excel?

Given a spreadsheet with 50000+ rows of data there is a subtotal cell on the bottom of each section like so:

col1     col2     col3     col4
_______________________________
val      anoth    yetan    more
val      anoth    yetan    more
val      anoth    yetan    more
     subtotal 5   开发者_如何转开发id = red
val      anoth    yetan    more
val      anoth    yetan    more
val      anoth    yetan    more
     subtotal 5   id = green

Reading the file in we would like the subtotal column to be on top of the sections of rows so how would you take the entire worksheet and flip it?

Unless I misunderstand your question you should be able to place your subtotal cell at the top with something like SUBTOTAL(2,A2:A500)

This macro did the trick for us. We had to reverse each column via macro individually but it took way less time than manually flipping everything.

http://www.teachmsoffice.com/excel-macros/reverse-row-column-order-in-excel,52