column + 3

Hello I am having some trouble with excel.
I have data in Sheet 2 arranged like this Column A Column B Column C Coloumn D Column E Column F Column G Column H Column I Column J
SP1 T R SP2 L G SP3 R L SP4

The SP# data is always 2 cells apart.

I want to put this into Sheet3 like this Column A Column B Column C Coloumn D Column E Column F Column G Column H Column I
SP1 SP2 SP3 SP4 SP5 SP6 SP7 SP8 SP9


basically just by copying across in sheet3, for the life of me i cant seem to work out how to reference just copy right and just look at the relevent equally spaced columns.

There is a lot of data and the SP do not always follow consecutive numbers, not that it really matters - but just in case one of you just say why dont you just drag SP1,SP2 etc

Most welcome for your help

Brilliant this worked ace! , Thank you, is there a way to rate you?