LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 09, 10:36 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Oct 2007
Posts: 50
Default Copy/pasteSpecial transpose, does not work.

When you're in the Paste Special dialog, check Values as well as Transpose.
Also, are there any hidden rows or columns?

* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC

"Phil Smith" wrote:

This is very simple. I copy this:

customer_id CustType active Sales Revenue
8174 CORE WHOLESALE Y $53,678

Using paste Special/transpose I get:

100801 EAST
1245 SPIN
1585 Swim
$100,987 SURF

The really funny thing is that second coloumn comes from data in a
coloumn that I deleted BEFORE the copy, because it contained customer
names that I did not want to publish here.

Shouldn't I get:

Customer_id 8174
CustType Core Wholesale
active Y
Sales Revenue $53,678

From that operation? I KNOW I should not get data that is NOT in what
is copied.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/pasteSpecial transpose, does not work. Luke M Excel Discussion (Misc queries) 0 September 14th 09 08:58 PM
copy, paste and transpose formula's into work sheets Derro Excel Worksheet Functions 2 January 13th 09 12:29 PM
Copy Chart and PasteSpecial PCLIVE Charts and Charting in Excel 2 October 26th 06 03:01 PM
Copy PasteSpecial not working Richard Buttrey Excel Worksheet Functions 9 August 11th 06 04:40 PM
Command Button for PasteSpecial - Values - Transpose Alisha Excel Discussion (Misc queries) 0 March 10th 06 09:39 PM

All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017