Is there any easy way to get from the bad setup to the good setup using VBA? I've been unable to think of a way to do this for any arbitrary sized table.
bad setup.JPG
good setup.JPG
Since no responses I just decided not to worry about viewing data that way.
Bookmarks