Is there a simple way to do this without creating a Pivottable?
G Gord Dibben Aug 17, 2004 #2 Ian If the number of rows does not exceed 256 you can use Copy>Paste Special>Transpose. Or use the TRANSPOSE Function(again limited) Gord Dibben Excel MVP
Ian If the number of rows does not exceed 256 you can use Copy>Paste Special>Transpose. Or use the TRANSPOSE Function(again limited) Gord Dibben Excel MVP
