Hi,
Here is some code that will transpose your 2 columns (not including the headings - if you need the headings done too, let me know and I'll amend my code for you).
Try placing a button (called "CommandButton1") on the worksheet that you are referring to in your original post, and place this code in the click event for that button (make sure you correctly specify the first and last rows that you want transposed):
This should do what you're asking (hopefully). If not let me know what isn't right about it.
Once you have completed the transposition, you can delete the button and this code, as it won't be needed any longer.
Hope this helps
Bookmarks