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..