Hello iincitr and Welcome to Excel Forum.
I believe the following does what you want:
1. For the type use: =IFERROR(INDEX(A$2:A$6,ROUNDUP(ROWS(A$1:A1)/3,0)),"")
2. For the values use: =IFERROR(INDEX(B$2:G$6,ROUNDUP(ROWS(A$1:A1)/3,0),MOD(1+2*(ROWS(A$1:A1)-1),6)),"")
3. For the dates use: =IFERROR(INDEX(B$2:G$6,ROUNDUP(ROWS(A$1:A1)/3,0),MOD(1+2*(ROWS(A$1:A1)-1),6)+1),"")
For future reference you will usually get faster responses if you upload a sample workbook by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Bookmarks