Transpose after CONCATENATE

[armymatt]

In Sheet 3 I Concatenate cells from Sheet 2... now that that worked... i want
to transpose the Conatenated cells (AZ6:AZ235) To Row 4 starting in Column BA.

I have tried this every way I know how and get #REF, 0, and error messages
saying it has to be the same shape cell.

anyone who can help me with this would be greatly appreciated.

Thank You Gurus

 

[Max]

In BA4, copied across to the 256 cols limit in xl03, ie to IV4:
=OFFSET($AZ$6,COLUMNS($A:A)-1,ROWS($1:1)-1,)
will return what's within AZ6:AZ209.

AZ210:AZ235 will need to be transposed horizontally in a separate line

If your excel version has > 256 cols, the above is obviously not an issue