Macro to transpose data from active sheet to new sheet

Hell All,

I am using Excel 2013 and have a problem as shown in the attached file.

I have set of Data in set of 6 Rows starting in Cell A1 going down. Sample shows only few data set.
The Macro should run till the last Row on the active sheet.
I want a Macro which when run should create a new sheet as shown.
The Output should start from Cell E4 down and J4 across.
I have colored the cells from explanation purpose only.

The Gross Weight and Net Weight Data will be copied and Transposed to the new Sheet.

Kindly note that the transposed data should be pasted as values as the original data contains formula.

Hope my explanation is clear.

Thanks in advance.

Sameer