Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I pivot a range of cells, i.e. from column to row?
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! |
#2
|
|||
|
|||
Copy then select cell where you want it to go and Edit/Paste-special, click
transpose button. -- HansM "Ernst" wrote in message ... 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! |
#3
|
|||
|
|||
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 "HansM" wrote: Copy then select cell where you want it to go and Edit/Paste-special, click transpose button. -- HansM "Ernst" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 97 - Selecting multiple cells from 2 different Pivot Tables | Excel Discussion (Misc queries) | |||
formulas referencing pivot table cells | Excel Worksheet Functions | |||
Formula help for using a range of cells! | Excel Worksheet Functions | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |