Macro Copy, Paste Transpose to Master Sheet

The following macro works wonderfully to consolidate my data from multiple sheets and put them on the next available line on a Master tab, however, I need to find a way to transpose the data when pasting into the Master tab.

HTML Code: 

In other words, each sheet has the following information listed in rows:
Unit #
Category
Mfg. Year
And on the Master tab, I need it to go in columns:
Unit Category Mgr Year , etc


Any help is appreciated..

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

AMAZING! Thank you!!!

Dingo!
You are welcome!
Could you please now close (Mark) this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.