Transpose Problem

H

Hazel

Hi All

In Sheet 1 of a workbook - row 1 is the header row - rows 2 : 50 columns B
& C hold the data.I need to move the data on to a single row I have tried
transpose and it always puts Column C underneath Column B in Column F instead
of being adjacent to each other i.e. Columns F & G. Somewhere I have seen a
maco that would do this but I cannot find it. Help please -- using office 2007
 
B

bj

in F1 enter
=INDIRECT("B"&INT(COLUMN()/2-2))
in G1 enter
=INDIRECT("C"&INT(COLUMN()/2-2))
Select F1 and G1 and copy
Select as many cells as you eed to enter the data in and paste
 
H

Hazel

Hi bj

Copied exactly your formula into F1 and it puts the header row in F1 in G1
done exactly the same and it puts cell C5 in G1. Tried altering all the
numbers in the formula's all to no avail.

Could it be something to do with using office2007??
 
Top