EXCEL 2007 Paste Special / transpose, But Retain Cell Reference

  BrendanKK 16:17 14 Sep 12
Locked

I want to convert data from rows to columns but retain a link to the original cell so that any changes to the original cell is reflected in the transposed table.

Can anyone suggest how I can Paste Special/transpose, but Retain Cell Referenced

Thanks in advance

  Woolwell 17:48 14 Sep 12

Wonder if you should be using a formula instead of pasting.

  BrendanKK 21:28 14 Sep 12

Can you suggest a formula?

  Woolwell 10:32 15 Sep 12

This is rather cumbersome way to do it and there may be better ways.

Original data is in column A. In Column B1 insert formula =$A1 and drag copy that formula down column B so that B2 become =$A2, etc. Then copy column B and paste transpose that column. You can hide column B when finished.

Advertisement

This thread is now locked and can not be replied to.

Nvidia Titan X release date, price and specs UK: Nvidia's new Titan X GP102 for 2016 launching on 2t…

1995-2015: How technology has changed the world in 20 years

This Superman ride is a real rollercoaster that you wear a VR headset on

Apple 12-inch MacBook review (2016): A question of port