Excel: Help!

Hello! I need to transpose some data from columns to rows like in the example below using VBA. It seems simple but for me, a beginner, it is a little bit difficult. A 3 B 2 B 8 A 6 B 1 to: A 3 6 B 2 8 1 I really hope that someone can help me!

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of May 24, 2014.

For more resources for Microsoft Excel