Copy 2nd,3rd, etc. rows below to a column based on number

Hello Everyone,

I am trying to find a way to copy & paste row data based on a number in column B (can't seem to paste the image here).

Basically if the number is '2' in column B, I want to copy Column A's data from the row below to the current column and want to skip the column I copied from. I want to keep doing this loop for every two rows (if the column in B is '2').

I want it to be every three rows if the number in column B is '3' and so on and so forth.

The current formula I am using for two is this =OFFSET(A2,1,0).

Trying to find a vba for this; thanks!