EXCEL 2007 Paste Special / transpose, But Retain Cell Reference

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

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

  BrendanKK 21:28 PM 14 Sep 12

Can you suggest a formula?

  Woolwell 10:32 AM 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.

Sony Xperia Z5 review: Hands-on with the phone which the Z3+ should have been

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

Get your photos turned into illos by some of the world’s best artists

What to expect at the September Apple event: Apple announces 9 September event, sends out invites