Transposing Cells... (Drag & Drop Taking Forever!)

Smythe22

New Member
Joined
Nov 14, 2005
Messages
5
Hi,

I'm after some direction on how I can take a group of formulas running right to left, and paste them running top to bottom, basically rotating the table 90 degrees ->.

If I paste special, with transpose checked, my formulas pick up different data.

All help greatly appreciated.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Without seeing the formulae, being able to spot what's going wrong is going to be a bit difficult. Please post examples of formulae, and post a snap-shot of the table "before" and "after" transposing.
 
Upvote 0
You need to make the cell references absolute, but adding $ in front of the Column reference and in front of the row reference.

E.g. If you have A1 in the formula you have to change it to $A$1. The easiest way is to place you curser at each occurrence of a cell reference and hit F4. This will automatically convert to an absolute reference. Then do the transpose.
 
Upvote 0
Thanks for the advise, I've used a transpose formula and Ctrl+Shift+Enter command which is doing the trick!

If I were to create absolute references I could be here all day, lots of data.

Thanks guys, great website... no doubt I'll be back soon!
 
Upvote 0
Forgot to say thanks for your help! - Transpose with an Array was the solution I went for. Thanks all for your assistance!
 
Upvote 0

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top