Loop copy paste to next column

Similar to: Copy Records where records = "a" at Column B - Syntax Error

Hi All,

This is very similar to something I am working on.

I have uploaded the same file with the required output in sheet 2.

If the cell is X select copy and paste adjacent cell.

But

If cell in next column is X copy and paste adjacent cell (same as before) into next column.

Can anyone help?

thanks Miles