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 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?