copy data

[Dummy Excel]

Hi All,
is it possible to have a formula that can copy the data down column C, G, K, and O and paste it in column Q?

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Depot	Type	Rego		Depot	Type	Rego		Depot	Type	Rego		Depot	Type	Rego		Rego	Depot	Type
2	city	Exc 1.8T	apples		beach	Exc 1.8T	blueberry		unit	Exc 1.8T	grapes		house		bread
3	city	Exc 1.8T	banana						unit	Jetter S	figs		house		rolls
4	city	Exc 1.8T	strawberry										house		chair

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula Q1 =C1 R1 =A1 S1 =B1 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[jim may]

Excel 2010

	Q
2	apples blueberry grapes bread

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula Q2 =C2&" " &G2&" "&K2&" "&O2 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Copy Down...

 

[Dummy Excel]

Hi Jim,
issue with that is it places everything in the same cell. I need everything in separate cells although all in one column - shouldve been a little clearer in my OP