Changing Direction Columns/Rows

G

Guest

Hi There-
I'm trying to use a pricing spreadsheet that's already been created and used
for several years in Excel, but I need to copy/paste it into a layout program
(Quark) where the columns and rows run the opposite direction. Any
suggestions on ways to use this spreadsheet and change the direction it
runs??? Otherwise I'm retyping pricing for our entire catalog - which is a
bit tedious and requires much proofreading. Help!!!
 
B

Bob I

Select, Copy, Paste Special, Transpose, will switch the contents columns
to rows. Try pasting into another sheet to play.
 
A

Asphalt Dancer

It worked!! Thank you, thank you.

Bob I said:
Select, Copy, Paste Special, Transpose, will switch the contents columns
to rows. Try pasting into another sheet to play.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare and import data using two spreadsheets 1
Changing Columns to Rows 2
Referencing rows to columns 3
inserting columns within certain rows only 4
Excel comments moving and changing sizes 2
"Global" Cut and paste from Name Manager? 1
changing columns into rows 2
How do I make sorts default to using the header row? 1

Top