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.

Should I upgrade to Windows 10? Why upgrade to Windows 10? Is Windows 10 good? The pros and cons of!…

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

This Uplifting Animation Celebrates Team GB’s Road to Rio

How to use Apple Music in the UK: Complete guide to Apple Music's features, including new features…