transform thousands of columns to A Single row

Hey pros, how do I transform thousands of groups of columns (each group has 6 columns) into A Single row (placed into another sheet) using Macro?

Since my data is large, so efficiency is also important.

Thanks very much.

transform.jpg