Transpose after CONCATENATE
 

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

Transpose after CONCATENATE
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"armymatt" wrote:
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