Using OFFSET &/or TRANSPOSE functions to copy multiple rows of data into multiple columns

Hello forum users,
First time user here. I want to correctly select and then copy the 1st, 3rd, 5th etc. rows of data (each of which has three columns) into one new, wide, row, which places side by side each of the three rows of data. I've tried sorting this out with the OFFSET function but can't manage to copy the data into the correct cells. I'm not a VBA user, so marcos would be hard for me to follow. I've also had a look at the INDEX fiunction to no avail. All the particulars of my data, what I've tried and what I would like to achieve are in the attached spreadsheet.
Any assistance/guidance would be greatly appreciated.
Thanks,
Demip.