transposing list from rows to columns

**david747** · 09-12-2007, 12:18 PM

Hello,

A picture is worth a thousand words. Please see attached.

Thank you in advance,
David

**StephenR** · 09-12-2007, 01:35 PM

One way:

Please Login or Register  to view this content.

**david747** · 09-12-2007, 01:55 PM

Where do I go with this code?

Thank you,
David

**StephenR** · 09-12-2007, 02:17 PM

In your workbook, press Alt-F11 to get into the VB editor, Insert > Module and paste the code. Then run the macro, which you can do from the spreadsheet via Tools > Macro > Macros.

**sgm020** · 09-12-2007, 02:19 PM

Originally Posted by david747

Hello,

A picture is worth a thousand words. Please see attached.

Thank you in advance,
David

Look at the sample file.

..

**david747** · 09-12-2007, 03:24 PM

Thank you everyone who tool part in helping me. Since you can not see me now, I am smiling from ear to ear; it takes very little to make me happy.

Seriously,
Thank you all.

~David