I have data in rows that I want to display in columns [duplicate]

This question already has an answer here:

• Convert matrix to 3-column table ('reverse pivot', 'unpivot', 'flatten', 'normalize') 2 answers

> Column 0   Column1    Column2   Column3   Column4 
>     1         Q1       DB67       DB68     DB69 
>     1         Q1       DB71       DB72               
>     2         Q2       DB74       DB75     DB76
>     2         Q2       DB77

I have data in the format above, I want the output to show as looping through taking the first two columns and the next value from Column2, Column 3, Column 4 and so on until one is blank as below then move on to the next system and value column

System  Value1 Value2
   1       Q1    DB67
   1       Q1    DB68
   1       Q1    DB69
   1       Q1    DB71

......