EXCEL 2007 Paste Special / transpose, But Retain Cell Reference

  BrendanKK 16:17 14 Sep 2012
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 2012

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

  BrendanKK 21:28 14 Sep 2012

Can you suggest a formula?

  Woolwell 10:32 15 Sep 2012

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.

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

Elsewhere on IDG sites

Best Black Friday Deals 2017

How modern book design was influenced by illustrated manuscripts

Best Black Friday Apple Deals 2017

Les meilleurs logiciels de montage vidéo gratuits (en 2017)