Spreadsheet help

  steviegee 09:42 03 Sep 2007

This is a bit complicated to explain! I have a spreadsheet which has information going horizontal and I want it to go vertical. In A1, A2, A3 and A4 have the same info i.e each one has ABC in. B1, B2, B3 and B4 has 1, 2, 3 and 4 in it. C1 has yes, C2 has no, C3 has true and C4 has false. I want it to go along the top! So A has ABC, B has the info from 1 in it C has 2 in it D has 3 in it and E has 4 in it. Understand!!! There is a lot on the spreadsheet so I need some sort of look up to save time.

  parrynz 09:46 03 Sep 2007

Select cells then click copy, select some balnk cells then Edit | Paste Special and click transpose box.

  steviegee 09:59 03 Sep 2007

That doesn't work as I need it. If someone doesn't mind me clicking the yellow envelope I can send an example of what it looks like now and what I want it to look like.

  VoG II 10:06 03 Sep 2007

In what way doesn't PasteSpecial > Transpose work?

  steviegee 10:29 03 Sep 2007

Its basically not what I require, matbe I havent explained it correctly. VoG do you mind me sending it to you?

  VoG II 10:53 03 Sep 2007

I've mailed you via the yellow envelope.

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

Elsewhere on IDG sites

WPA2 Hack Latest News: How Secure is your Wi-Fi?

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Best kids apps for iPhone & iPad

Comment utiliser Twitter ?