changing data from colums to rows

hi,

i am trying to re-arrange data that will come from an measuring system to a csv file
i have attached a file which shows how the data will arrive into a csv file ( sheet 1) and how i would like it to look ( sheet2). the amount of rows of data can vary. any help would be appreicated