Autofill A Column From Row Data

Hello everyone,

I want to be able to autofill down a column using row data...

Is this possible? I've messed around with index, indirect, and lookups, but I can't seem to figure out how I would do this. If you do give me responses, I would appreciate an explanation, as I am new to the complicated formulas of excel.

I attached a sample of my data because I know my explanation is incomplete. I have a lot more data, so I wouldn't want to just copy and paste.

Thanks in advance