Complicated Custom Auto Fill

Hi Excel forum! I love this forum and this is my first post. This is probably a multi-part question, but I'm pretty desperate. Merry Christmas to me I think I've really screwed myself.

I'm trying to re-sort some survey data in a way that makes sense to the end user. Each row is the survey date for 6 criteria for 6 cases.
A1= user1 name B1= CaseName1 C2= CaseName2....repeat four columns then....H1-M1: Case 1 answers 1-6 N1-S1 Case 2 answers 1-6

Mess. I need it to look like this:

A1 = user1 B1 = CaseName1 C2-H2 = Case 1 answers 1-6
A2 = user1 B2 = CaseName2 B2-H2 = Case 2 answers 1-6


I used this formula =INDIRECT("A"&FLOOR(ROW(A6)/6,1)) to repeat A1 every six rows, so column A is solved (though I am looking for a step-by-step explanation of how that formula works!!!)

I very much need help to fill out the rest. I have hundreds of rows of this one-user-gives-answers-for-six-cases-on-a-single-row that I need to autofill to turn into many more case-by-case rows.

I wish I could SUM the point values, but I actually have to show each criteria in a separate column.


Finally, you can see that there are often blanks and there is only info for 2 or 3 cases - it's rare someone actually has info for 6 complete cases. if there is a magical Array formula or something that will do ALL THIS and only populate rows WITH case data or if someone has an easy way to eliminate rows with blank case data (with the autofill for A1, there will always be data in A1 - i know how to eliminate blank rows) i will send you cookies.

Please and thanks and happy holidays.

UPDATE - I figured out how that INDIRECT formula works. SWEET.

However, I'm still in trouble for the rest of it. Please help. Thanks!