E Eric Sep 22, 2003 #1 Is there an easy way to flop columns and rows? Meaning, I want to make row 1 be column 1, row 2 to column 2, etc. Thanks!
Is there an easy way to flop columns and rows? Meaning, I want to make row 1 be column 1, row 2 to column 2, etc. Thanks!
D dvt Sep 23, 2003 #3 Eric said: Is there an easy way to flop columns and rows? Meaning, I want to make row 1 be column 1, row 2 to column 2, etc. Thanks! Click to expand... Select the area to be flipped, Edit | Cut, Paste Special | Transpose. Or use the TRANSPOSE function. Dave dvt at psu dot edu
Eric said: Is there an easy way to flop columns and rows? Meaning, I want to make row 1 be column 1, row 2 to column 2, etc. Thanks! Click to expand... Select the area to be flipped, Edit | Cut, Paste Special | Transpose. Or use the TRANSPOSE function. Dave dvt at psu dot edu