I'm sure there's an easy way to do this. It might not even involve a
macro. I'm receiving data in the following crosstab format:

CountynameX acount bcount total
acount% bcount% 100%
CountynameY acount bcount total
acount% bcount% 100
and so forth.

I want the data in columns:

CountynameX acount acount% bcount bcount%
CountynameY acount acount% bcount bcount%

I don't need the totals or the 100% in my table at all.
What's the easiest way to accomplish this? The more automated the
better. I'll be doing it for several files every quarter.
Thanks!