Convert Columns to Rows

[TripletDad]

I need help converting columns to rows. I think this is an "Index" function, but have no idea how to use it...

Basically, I'm trying to list product images. Each product is assigned a row on the spreadsheet (Main) with multiple columns where I can list the image. I need each column on the Main sheet to translate to a row on the Image spreadsheet.

I will be listing Images a TV in the following cells on the Main Sheet:

'Ignify TV Main'!X2
'Ignify TV Main'!Y2
'Ignify TV Main'!Z2
'Ignify TV Main'!AA2
'Ignify TV Main'!AB2
'Ignify TV Main'!X3
'Ignify TV Main'!Y3
'Ignify TV Main'!Z3
'Ignify TV Main'!AA3
'Ignify TV Main'!AB3
...etc

Data from these cells needs to be placed in the following cells:

'Ignify Image Data'!A2
'Ignify Image Data'!A3
'Ignify Image Data'!A4
'Ignify Image Data'!A5
'Ignify Image Data'!A6
'Ignify Image Data'!A7
'Ignify Image Data'!A8
'Ignify Image Data'!A9
'Ignify Image Data'!A10
...etc


The "Main" sheet has about 500 rows, so I need to be able to drag the formula down approx 2500 columns on the Image sheet.

Hopefully this makes sense... I'm trying hard to wrap my brain around this, but it's hard!!!

Thanks for any help...

-Jeff

 

[AlphaFrog]

Put this in 'Ignify Image Data'!A2 and drag down.

=INDEX('Ignify TV Main'!$X$2:$AB$500, INT(ROW(A5)/5), MOD(ROW(A5),5)+1)

 

[TripletDad]

Perfect!

Thank you!!!

...wish I could learn this stuff!

 

[TripletDad]

Put this in 'Ignify Image Data'!A2 and drag down.

=INDEX('Ignify TV Main'!$X$2:$AB$500, INT(ROW(A5)/5), MOD(ROW(A5),5)+1)

Alpha,

Is there a way to write this so it doesn't show a "0" value if there is no data in the "TV Main" cell?

 

[AD_Taylor]

Alpha,

Is there a way to write this so it doesn't show a "0" value if there is no data in the "TV Main" cell?

=IF( INDEX('Ignify TV Main'!$X$2:$AB$500, INT(ROW(A5)/5), MOD(ROW(A5),5)+1) = 0, "", INDEX('Ignify TV Main'!$X$2:$AB$500, INT(ROW(A5)/5), MOD(ROW(A5),5)+1) )