Move From Column To Row - Power Query?

I'm using Excel 2016 version and I'm needing to move data from a column into rows. I'm not sure how to go about doing it without manually copying and pasting, which would take forever. My workbook has two tabs... both needing the same thing but the number of columns in the final table would be different. My example spreadsheet is attached with an easy to understand example.

Can someone possibly help with this one? I'm not familiar with Power Query but think that would probably do the trick.

Based on the layout of your sample in post #1, you can use these formulas in C3:

Sheet2 =INDEX($A:$A,ROWS($1:1)*6-3+COLUMNS($A:A))
Sheet4 =INDEX($A:$A,ROWS($1:1)*7-4+COLUMNS($A:A))

Drag the formula to the right and down.

Originally Posted by 63falcondude

Based on the layout of your sample in post #1, you can use these formulas in C3:

Sheet2 =INDEX($A:$A,ROWS($1:1)*6-3+COLUMNS($A:A))
Sheet4 =INDEX($A:$A,ROWS($1:1)*7-4+COLUMNS($A:A))

Drag the formula to the right and down.

Thank you so much!

You're welcome. Happy to help.

Thanks for the rep!

Hi, is there anyway to revert this process?