Moving column headers to row headers

Question

I am trying to move my columns to rows... here is an example of what I want to do, but my document is very large... this is how it currently is, and blow is how I want it to be without typing everything over again:

         a           b                c

1      yes        no          maybe

2        1          2                1

3        2          1                3

4        1           1               1

          a           b                c

1       yes         1                2

2       no          2                 1

3     maybe      1                 3

Answer 1

I am trying to move my columns to rows... here is an example of what I want to do, but my document is very large... this is how it currently is, and blow is how I want it to be without typing everything over again:

         a           b                c

1      yes        no          maybe

2        1          2                1

3        2          1                3

4        1           1               1

 

          a           b                c

1       yes         1                2

2       no          2                 1

3     maybe      1                 3

Based on the limited sample you provided...

Maybe something like this...you can copy the range then transpose it to a new range.

Select the entire range A1:C4

Right click>Copy

On a new sheet (maybe?) select cell A1

Right click>Paste Special>Transpose>OK

Make sure it looks like what you want then you can delete the original data.

--

Biff

Microsoft Excel MVP

Answer 2

If your document is very large won't you run out of columns?

I am trying to move my columns to rows... here is an example of what I want to do, but my document is very large... this is how it currently is, and blow is how I want it to be without typing everything over again:

         a           b                c

1      yes        no          maybe

2        1          2                1

3        2          1                3

4        1           1               1

 

          a           b                c

1       yes         1                2

2       no          2                 1

3     maybe      1                 3

---

Tushar Mehta (Technology and Operations Consulting)

www.tushar-mehta.com (Excel and PowerPoint add-ins and tutorials)

Microsoft MVP Excel 2000-Present

Answer 3

Hi,

Highlight the range, copy, paste special, transpose