Convert data from 3 rows to 3 columns repeating

Transpose.JPG

Please help me in converting my data in row to columns as in the image by any formula or function.
Advance Thanks

Hello and welcome to the forum.

Try this in D2:

=INDEX($B:$B,ROWS($1:1)*3-3+COLUMNS($A:A))

Drag the formula to the right and down.