Transpose after CONCATENATE

  • Thread starter Thread starter armymatt
  • Start date Start date
A

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
 
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
 
Back
Top