I want to switch vertical column data into horizontal rows,
in excel.
... or say transfer first (secon, third) ten rows of one sheet,
into first (second, third) columns of another . . . .
Any quick way to do this?
RL
On Sat, 18 Apr 2026 18:34:03 -0400, legg <legg@nospam.magma.ca> wrote:
I want to switch vertical column data into horizontal rows,
in excel.
... or say transfer first (secon, third) ten rows of one sheet,
into first (second, third) columns of another . . . .
Any quick way to do this?
RL
LibreOffice has the "transpose" function built in: ><https://ask.libreoffice.org/t/how-do-i-convert-rows-into-columns-or-vice-versa-in-calc/7125>
- Select the area of data you want to "convert", e.g., click top-left
cell, then shift-click bottom right cell. You should how have copied
all the rows of data that you want to convert into columns of data.
- Hit CTRL-C to copy.
- Go to a new worksheet, click the cell where you want to paste your
new columns.
- Either hit Shift-CTRL-V, or use Edit > Paste Special... from the
toolbar to bring up this dialog (missing):
Ensure that the Transpose option is selected, then click OK. Done!
Video:
<https://www.youtube.com/watch?v=xM6_mhmnk7o>
"How to Transpose Data in LibreOffice Calc"
More of the same: ><https://www.google.com/search?q=libreoffice%20transpose%20rows%20to%20columns>
I want to switch vertical column data into horizontal rows,
in excel.
... or say transfer first (secon, third) ten rows of one sheet,
into first (second, third) columns of another . . . .
Any quick way to do this?
RL
On Sat, 18 Apr 2026 18:34:03 -0400, legg <legg@nospam.magma.ca> wrote:
I want to switch vertical column data into horizontal rows,
in excel.
... or say transfer first (secon, third) ten rows of one sheet,
into first (second, third) columns of another . . . .
Any quick way to do this?
RL
LibreOffice has the "transpose" function built in: ><https://ask.libreoffice.org/t/how-do-i-convert-rows-into-columns-or-vice-versa-in-calc/7125>
- Select the area of data you want to "convert", e.g., click top-left
cell, then shift-click bottom right cell. You should how have copied
all the rows of data that you want to convert into columns of data.
- Hit CTRL-C to copy.
- Go to a new worksheet, click the cell where you want to paste your
new columns.
- Either hit Shift-CTRL-V, or use Edit > Paste Special... from the
toolbar to bring up this dialog (missing):
Ensure that the Transpose option is selected, then click OK. Done!
Video:
<https://www.youtube.com/watch?v=xM6_mhmnk7o>
"How to Transpose Data in LibreOffice Calc"
More of the same: ><https://www.google.com/search?q=libreoffice%20transpose%20rows%20to%20columns>
On 4/18/26 18:34, legg wrote:
I want to switch vertical column data into horizontal rows,
in excel.
... or say transfer first (secon, third) ten rows of one sheet,
into first (second, third) columns of another . . . .
Any quick way to do this?
RL
rotate your monitor 90 degrees (ducking...)
Data itself took about two weeks to record, with the recorder
losing its hard drive half way through (had a cloned drive handy).
Still have to figure that out - can be read as slave but no longer
reports its identity to the bios - is just 'hard drive'.
Seldom find something that computers are actually really meant
for and are good at . . .
| Sysop: | Jacob Catayoc |
|---|---|
| Location: | Pasay City, Metro Manila, Philippines |
| Users: | 4 |
| Nodes: | 4 (0 / 4) |
| Uptime: | 494928:16:59 |
| Calls: | 162 |
| Files: | 568 |
| D/L today: |
14 files (349K bytes) |
| Messages: | 74,957 |