Change Cell Reference from vertical to horizontal

[Hanniball]

Hi,

I am new to NeoOffice. I hope what I want to do can be done in NeoOffice:

I have a column filled with names. On the next sheet I want to use these names as header for those columns.

Is that possible?

Regards

Hanniball

[yoxi]

The answer is Yes if you're prepared to do it manually - there doesn't appear to be any way to do this using Fill (though someone may have written a macro to do this, with any luck - I'll see what I can find). The manual version - if your column of names on sheet1 is thus:

[jgd]

You can use the Array function: TRANSPOSE.

Select Cells A1 to F1 in Sheet2 (in your example) then enter =TRANSPOSE(Sheet1.A1:A6) (use the function wizard, I don't get that to work if I enter (Sheet1.A1:A6) by hand, why?) and press Return.

You can select only cell A1 in Sheet2, use TRANSPOSE, you get Crosby in that cell, then drag the mouse on the first row of Sheet2. The rows is filled with Godley, etc.

Hope that helps

Jacqueline

[yoxi]

Neat function!

But I couldn't get the 'drag cell A1 in sheet2' to do anything.

I notice that the wizard creates an array across the cells in sheet2, so that each cell shows the same thing: {=TRANSPOSE(Sheet1.A1:Sheet1.A6)} - following the instructions in Help, if you select (in this example) cells A1 to F1 in sheet2, type =TRANSPOSE(Sheet1.A1:Sheet1.A6) in the formula bar and then hit cmd-shift-Enter, it creates the array above in the same way the wizard does.

- padmavyuha

[jgd]

[yoxi]

[jgd]