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