How do you successfully transpose rows into columns in Excel?

15 New Member

I have been searching threads for a while and found the instructions listed below many times, however when I get to step 6 and select to save, I always receive the following error, "The information cannot be pasted because the copy area and the paste area are not the same size and shape". Does this function only work if the number or rows and number of columns are the same number? Does anyone have any suggestions for me? I greatly appreaciate any help you can provide.
Thanks,
Jennifer

Transpose the Data in Microsoft Excel
1. Start Microsoft Excel and open the spreadsheet that you created in step 5 of the "Export the Data to Microsoft Excel" section.
2. Press CTRL+HOME to go to cell A1. Press CTRL+SHIFT+END to select all of the data.
3. On the Edit menu, click Copy.
4. On the Insert menu, click Worksheet.
5. On the Edit menu, click Paste Special.
6. In the Paste Special dialog box, click to select the Transpose check box, and then click OK.
7. On the Format menu, point to Sheet, and then click Rename. Type a name for the sheet that contains the transposed data. If you want, click Save As on the File menu to export the data directly to text from Microsoft Excel.
8. Save and close the workbook, and then quit Microsoft Excel.

Sep 5 '09 #1

Subscribe Reply

12590

NeoPa

32,579

Recognized Expert Moderator MVP

It seems to me that you are not following the instructions properly. You seem to have some cells selected before you try the Paste. This is not what the instructions say!

You must have only a single cell selected for the paste to work smoothly. Please try this (or the instructions posted exactly as stated) and I'm sure this will work for you. I'm confident because I've used it many times myself. Please let us know how you get on.

PS. Although we have no Excel forum as such, I will move this to the Access / VBA forum where we often deal with questions pertaining to Excel issues.

Sep 6 '09 #2

jenniferhelen

New Member

Thanks NeoPa for your reply again.
I don't have any fields selected when I paste and I found the transpose function to work successfully when I reduce the amount of data to 100 columns. I wonder if I am running into a column limitation in Excel? If the transpose works successfully I should have 317 columns. I am working with Excel 2003. Are you aware of any limitation here?
Thanks again
Jennifer

Sep 13 '09 #3

AJMegaughin

New Member

Jennifer,
I believe your suspicion is correct.
If memory servers, Excel 2003 allows you to create columns up as far as column IV. If you work it out this equates to column 256.

AJM.

Sep 18 '09 #4

NeoPa

32,579

Recognized Expert Moderator MVP

Sorry Jennifer I missed this.

I can confirm the previous post. Excel only has 256 columns. This has been true since before the Rows were increased from 16K to 64K (in 97 I think), and maybe before then even.

I'm afraid you've hit a barrier there.

Sep 18 '09 #5

jenniferhelen

New Member

Thanks everyone for your help.
Jennifer

Sep 20 '09 #6

Similar topics

6510

store procedure to transpose rows to columns

by: lenygold via DBMonster.com | last post by:

Chris Eaton created a SP to to transpose rows to columns : Here is an example of a rowtocol stored proc that takes a SQL statement as the first paramter, a delimiter as the second parameter and the ouput (in the 3rd parameter) is the rows coverted to a column with the delimiter specified used to separate the row values. CREATE PROCEDURE rowtocol (IN p_slct VARCHAR(4000), IN p_dlmtr VARCHAR(4000), OUT lc_str VARCHAR(4000)) LANGUAGE SQL...

DB2 Database

2920

A simple grid rows / columns.

by: viki1967 | last post by:

Hi all. I need your help. I realize this script and I do not know where to begin: 1) A simple grid rows / columns. 2) The first column contain an input type = "checkbox" 3) When select the input type, the line should change color than the other rows, and you should open a popup window.

Javascript

7045

Unhiding rows/columns in excel 2007

by: ronakinuk | last post by:

how can i unhide rows/columns in excel 2007

Microsoft Access / VBA

3028

code for getting maximum rows in excel sheet using perl script

by: sree ram | last post by:

code for getting maximum rows in excel sheet using perl script

Perl

4726

how to insert multiple rows in excel using vba

by: ronakinuk | last post by:

how to insert multiple rows in excel using vba how to insert multiple rows in excel using vba how to insert multiple rows in excel using vba

Visual Basic 4 / 5 / 6

1477

What is the formula to highlight rows in Excel?

by: Eddie Rivera | last post by:

Does anyone know of a formula to highlight rows in Excel? I have used Conditional Formatting but I need a formula to find past due and upcoming dates. Thanks in advance for your help!

Microsoft Access / VBA

9528

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10455

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10228

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9052

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6788

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5573

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4116

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3731

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2925

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General