Vertically list from J10 in a seperate sheet

[Crakkermack]

Hey all, I have a series of items that are in a horizontal diplay with formulas from I559 - AE559 /sheet is "Sep canteen".
I want to move them to run vertically list from J10 in a seperate sheet "Sep data". Could some one please give me formula for this?
Have tried a couple of methods, but keep getting horizontal data.

[gak67]

In J10 try

Please Login or Register  to view this content.

and confirm it with Ctrl + Shift + Enter, then drag it down.

[FDibbins]

Another method using a regular formula, you will need to adjust the ranges to suite...

=INDEX($B$3:$G$3,ROW(A1))
copied down

[Crakkermack]

Hi Gak, Thanks' but maybe these images may help you understand my dilema:Sep Canteen.jpgSep data.jpg

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

[Crakkermack]

Still keeps working horizontal but cannot get it vertical. This is what I tried in J10 "Sep canteen"

[Crakkermack]

Still keeps working horizontal but cannot get it vertical. This is what I tried in J10 "Sep canteen" =INDEX('Sep canteen'!I559:P559,ROW(A1))

[Crakkermack]

Sorry FB, I cant work out how to attach a sample.

[azumi]

click "Go Advanced" button next to "Post Quick Reply" button and then find Paperclip button to attach your sample workbook.

Thanks

[gak67]

The transpose should work. Try it this way: In 'Sep Data'!J10 try:

Please Login or Register  to view this content.

Then select J10:J38 (there are 28 columns between I and AE, so 28 rows). Push the F2 button then Ctrl + Shift + Enter.

For Ford's method try:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

The difference between mine and Ford's is the extra comma, although it shouldn't be needed.

[gak67]

I just noticed you said you used this: =INDEX('Sep canteen'!I559:P559,ROW(A1))

You need to use this: =INDEX('Sep canteen'!$I$559:$P$559,ROW(A1))

[Crakkermack]

Brilliant!!