Macro for Transposing Columns into a new Row

**profluent** · 04-01-2009, 08:24 PM

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

**Special-K** · 04-01-2009, 08:46 PM

Can't you just use copy and Paste Special with Transpose ticked? Even with a block copy this should work.

Everything would then be in columns and then it would be just a simple case of cut and pasting columns where you wanted them

**profluent** · 04-02-2009, 05:07 AM

That would be ok, but I'm dealing with hundreds of lines of data. Not only do I have to manually copy and paste special > transpose every line, but I also have to insert several new rows to do it.