how to swap columns to rows view

I have following two columns of data in excel 2007:

a  1 b  2 ... 

What I need to swap the view to:

a  b  ... 1  2  ... 

I think there is way to do it in excel 2007. Is this possible?


No VBA programming necessary.

Just Copy, Paste Special, then check the "transpose" box.

Category: microsoft excel Time: 2009-03-09 Views: 2

Related post

  • How to swap columns in such a file? 2012-02-13

    I have a text file, each line is stored like this : "Video or movie" "parent" "Media or entertainment" "1" "1" "1" "0" "0" I want to swap the columns 3 with 2, i.e. "Vide

  • How to swap 2 different component views in Lightning? 2015-08-25

    What is the best way to create a views in Lighting? And how can i navigate from one view to another? For Ex. I have 2 different components, c:ListInfo and c:Elementinfo, When i click one element of the c:ListInfo it will redirect or navigate to the c

  • How to swap column values to be column name in R 2016-01-31

    I have created a minimal example to demonstrate my problem. I have a data frame and I want to swap the columns to be based on the values within the columns. In other words I want to convert something like this: structure(list(index = c("a", &quo

  • How to select columns in editor views 2010-12-20

    This may be a plugin/editor specific question, but I'm wondering if there is a way to select column 4-10 rows 1-10, for example in any editor or some editors within Eclipse? Note: this can be done with Notepad++ and Vim for example. --------------Sol

  • How to select columns in editor view for Eclipse on OSX 2011-02-02

    Same as this question, but for OSX. In short: how to I enter rectangular selection mode on OSX? I see a button for doing this with the standard useless "text editor" that is default with eclipse, but not with the "javascript editor" wh

  • Is there a way in Numbers to flip columns with rows? 2011-06-07

    Is there a way in Numbers to flip columns with rows ? I have several tables in my sheet and I need to swap columns with rows for each table. e.g. A1 A2 A3 B1 B2 B3 C1 C2 C3 should become: A1 B1 C1 A2 B2 C2 A3 B3 C3 thanks --------------Solutions-----

  • How to swap row/column major order? 2014-06-04

    I'm trying to get a sprite sheet clipped in the right order but I'm a bit stumped, every iteration I've tried has tended to be in the wrong order. This is my current implementation. Frames = (TempSurface->h / ClipHeight) * (TempSurface->w / ClipWidt

  • Swap columns inside every other row with Views and Bootstrap 2015-08-14

    i want to create block with views.I want style output like image bellow. Sorry i add image because my english is not good and i cant explain what i want --------------Solutions------------- One solution is to customize the view output to include the

  • How to remove unused columns and rows from being displayed in calc 2010-10-14

    Does anyone know how to remove unused columns and rows from being displayed in an calc file? I want the display to just be solid grey or white with no grid or column/row names. --------------Solutions------------- You can hide unused r

  • How Can I Paste Multiple Values in a SharePoint Checkboxes (Multiple Selections) Column in Datasheet View? 2013-10-06

    I am trying to copy a column of data from an Excel spreadsheet, exported from a proprietary Lotus Notes database application (groan), to a SharePoint list presented in Datasheet view. The Notes app exports this column of data, created by a user makin

  • How can we swap columns in two-column regime preserving hyperlinks? 2014-04-17

    Please save your time and energy on this question, some solutions exist. I have been helping with Arabic-English (right-to-left typesetting) and English-Arabic (left-to-right typesetting) indices typesetted in one document, see more in Switch twocolu

  • Views Table with Taxonomy Terms for Columns and Rows 2015-11-10

    I have a content type for manuals that has a vocabulary for "Model Year" and another for "Model Name" with a file upload that is for owners manuals for the specific Model Name + Model Year. I want to push this content type into a view

  • How can I have 2 rows and 3 columns of desktops/workpaces in Lubuntu? 2011-05-21

    How can I have 2 rows and 3 columns of desktops in Lubuntu? (Instead of having 1 row which is the default setting.) I haven't found a setting, yet. --------------Solutions------------- With LXDE the fine adjustment of desktop appearance is reduced as

  • How to change the image size (column and row number) into the same size 2011-08-26

    I'm using IDL program. But I have a question how to convert different row and column number (row/col) to the same size of column and row number of 36 time series NDVI images. These images grouped into three different column and row numbers. When I do

  • Change rows and columns in list views 2012-02-15

    I'm facing another strange issue from my users, who love Excel sheets. Can I transform / mix / change rows and columns in one list using only a views? Is it possible to make this view (or list): ... from this original one? The original list has one r

  • How do I transpose data in columns to rows? 2012-03-08

    How do I transpose data in columns to rows? If the data is: Joe some city some state Bob no city no state and I use Paste Special ยป Transpose, I get Joe some city some state Bob no city no state What I want is: Joe some city some state Bob no city no

  • Oracle: How to create a not null column in a view 2012-06-19

    Given a table like: CREATE TABLE "MyTable" ( "MyColumn" NUMBER NOT NULL ); I want to create a view like: CREATE VIEW "MyView" AS SELECT CAST("MyColumn" AS BINARY_DOUBLE) AS "MyColumn" FROM "MyTable&qu

  • How to remove the "blank" column or row in the pivot table 2013-03-06

    I want my pivot table to auto update/refresh when I add more data to the table that I am generating the pivot table from. In that case I have selected the entire worksheet to generate the pivot table. Because I have blank columns and rows in my works

  • How to add a new row of just one column, below another row of 3 columns? 2013-04-05

    How do I add another row of just one column below another of 3 columns? In the image below I have tried to add a row below the 3 column row but it added a 3 column row instead of 1 and I am unable to make it a 1 column row. Thanks in advance. -------

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 1.094 (s). 13 q(s)