rows to columns

Please refer to attached JPG.



I am trying to change the data in my rows to columns



I have data as per the attached picture in columns B-I



I would like the rows to be pasted to columns as per columns M-Q



so row 1 ends up as the first lost of data in M-Q and row 2 ends up as the second lot of data.



There are numerous rows in my actual file.

Attached Images

data1.jpg (85.0 KB)

rows to columns