Man, I have been searching for hours for a macro that transposes columns into a new row that would work for me. I was hoping one of you smart people might be able to help.

Here is what I have (the commas are signifying columns):

OptionName1, OptionName2, OptionName3, OptionValue1, OptionValue2, OptionValue3

This is what I need to get:

OptionName1, OptionValue1
OptionName2, OptionValue2
OptionName3, OptionValue3

Any help would be very much appreciated. Thanks, Matt