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

OnePlus 5 review

30 UK artists have created vibrant posters celebrating Pride London

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?