concatenate 3 rows ,and transpose it into single column in another sheet

hello friends ,
i am trying to concatenate 3 rows ,and transpose it into single column in another sheet.
first and second row is fix , 3rd row changes .
for example :
1 ) first column of output would be first(R) & second(R) & THIRD(R)
2 ) second column of output would be first(R) & second(R) & FOURTH(R)
3 ) third column of output would be first(R) & second(R) & FIFTH(R)
4 ) and so on .....

i have attach sample file , please note just to simplify things only numbers and alphabets are been used ,
also number of rows and columns are not fixed .....

Simply

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

Regards Mick

thanks @jindon , @oeldere, @MickG..
different ways same answer