Copy paste data from a column to a row

B

beanoburrito

Joined
Apr 18, 2013
Messages
2
Reaction score
0
Hello all,

I'm currently trying to paste data that I have arranged in columns into a row format instead.

Example: I Say you have E69:E73 setup with SUM formulas for the above cells

(say E69 is SUM(E10:E18), E70 is SUM(E19:E127), ... etc)

and you want to paste that into a row format where the row/col isn't changed...

making E80:I80 the new cells that contain the exact same formulas.

Note that F69:F73, G69:G73, and so on, all also have the formulas that need to be pasted respectively into E81:I81, E82,I82, etc...

any ideas on how to do this without doing it manually?
 

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

Auto Fill formula from a column to row 1
Need macro to copy a hidden row 3
moving alot of data (10000 cells) from a column to a row 3
Locate non-blanks in a column and copy certain data from the row 1
Copy / paste from a table in word .doc to excel .xls worksheet 1
transfer data from 3x15 grid to a single list? 3
Copy and Paste Formula from ActiveCell to cells in 13 columns priorto the active column 1
copy data and formulas from a column and paste into a row 1

Top