How do I pivot a range of cells, i.e. from column to row?


G

Guest

How do I pivot/transpose the data from a range of cells from, say, a column
to a row? I imagine it should be very simple, but I haven't found out how
yet. For instance:

row#
1 data 1
2 data 2
3 data 3
4 data 4

to

column# 1 2 3 4
data1 data2 data3 data4


hope someone has an answer. Thanks!
 
Ad

Advertisements

H

HansM

Copy then select cell where you want it to go and Edit/Paste-special, click
transpose button.
 
Ad

Advertisements

G

Guest

Thanks Hans,

I tried something similar: I copied, then selected a RANGE of cells and
tried Past-special-Transpose, rather than just selecting a single cell and
Paste-special-Transpose. Thanks for specifying exactly what to do
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top