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

[Smythe22]

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.

 

[GlennUK]

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.

 

[NBVC]

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.

 

[Smythe22]

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!

 

[erik.van.geit]

coincidence ?
for those who don't know the transpose-formula here is an example in a really very recent thread (just answered before seeing this post )
http://www.mrexcel.com/board2/viewtopic.php?t=178962

 

[Smythe22]

Forgot to say thanks for your help! - Transpose with an Array was the solution I went for. Thanks all for your assistance!

 

[RAM]

Thanks Erik for the link. Really good.

RAM