Transpose Problem
 

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

--
Many thanks

hazel

Transpose Problem
 

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



"Hazel" wrote:

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

--
Many thanks

hazel

Transpose Problem
 

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??


--
Many thanks

hazel


"bj" wrote:

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



"Hazel" wrote:

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

--
Many thanks

hazel

Transpose Problem
 

are you sure you have the /2 in G1?
that is only way I can make it put the value in C5 into G1
I have 2003
if you dont want the header information if F1 and G1.
change the "-2" to "-1" in both cells

"Hazel" wrote:

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??


--
Many thanks

hazel


"bj" wrote:

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



"Hazel" wrote:

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

--
Many thanks

hazel