HSTACK, Autofill, and Skipping rows of data

Hi everyone. I had a question about data and manipulating it. I am currently working on collecting data for my thesis and I have created an excel sheet and it is going pretty well. However I am having trouble formatting my sheet.

I have a sheet for the original data and a condensed version with the information I care about. This was relatively easy to do. The problem I am running into is the I have 3 sets of data per participant. So I organized it as E_1, E_2, E_3. Basically it is the first set, second set, and third set listed across the columns. The rows are the participants ID number.

The problem I am running into is getting the data from the condensed sheet into the organized sheet effectively. I originally was just copying and pasting each row into the other sheet but I am supposed to have 150 participants so doing this for every one would be annoying. So I turned to code to make it less difficult. I was using HSTACK which does make it easier. However when I try to autofill, it goes to the next available cell instead of skipping 3 cells. So it looks kinda like this =HSTACK(A1:C1,A2:C2, A3:C3). Then the next one should be =HSTACK(A4:C4,A5:C5,A6:C6) and so on. It is autofilling it as =HSTACK(A1:C1,A2:C2, A3:C3) then =HSTACK(A2:C2,A3:C3, A4:C4). I don't know how to fix this. I thought that maybe it just needed more examples of the format so I put the HSTACK filled out correctly in rows 1-4. Sometimes it recognizes that it needs to skip 3 but it is inconsistently doing so. And it is like back tracking (like HSTACK(A1:C1, A2:C2) then HSTACK(A2:C2, A3:C3)) instead of just carrying on the pattern. Am I autofilling incorrectly? I am so confused and I am sure there is a way to get it to work but I cannot figure it out on my own