From Newsgroup: sci.electronics.repair

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
--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

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> --
Jeff Liebermann jeffl@cruzio.com
PO Box 272 http://www.LearnByDestroying.com
Ben Lomond CA 95005-0272 AE6KS 831-336-2558

--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

On Sat, 18 Apr 2026 17:33:18 -0700, Jeff Liebermann <jeffl@cruzio.com>
wrote:

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>

Thanks Jeff. I've got libre-office and will give that a shot.

RL
--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

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...)
--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

On Sat, 18 Apr 2026 17:33:18 -0700, Jeff Liebermann <jeffl@cruzio.com>
wrote:

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>

Excellent, or should I say LibreOfficellent.

Getting every second transposition reversed, cells split and
correllated into matching tables less than ten rows deep ( I can
still count to ten with relative safety ) got it all done in one
day.

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 . . . .

RL
--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

On Sun, 19 Apr 2026 11:42:54 -0400, Paul Babiak <noway@uwish.com>
wrote:

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...)

You better . . .

Any thoughts on cooperative real estate in some collapsing
berg, or are you still nursing relatives. ?

RL
--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

On Mon, 20 Apr 2026 09:45:59 -0400, legg <legg@nospam.magma.ca> wrote:

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'.

Trashed partition table, perhaps. Something in your data logger may
have over-written the beginning of the parition table. These might
work:

"How to Recover a Partition Table" <https://www.cleverfiles.com/howto/recover-partition-table.html>

Seldom find something that computers are actually really meant
for and are good at . . .

Before AI, computer repetition and practice did not improve the
results. With AI, there's some hope that computers will learn from
their mistakes.

"I just fix computers. I don't use them".
Me, in about 1985

"If this stuff worked, you wouldn't need me".
Me, again. It's on my business card.

Good luck...
--
Jeff Liebermann jeffl@cruzio.com
PO Box 272 http://www.LearnByDestroying.com
Ben Lomond CA 95005-0272 AE6KS 831-336-2558

--- Synchronet 3.21f-Linux NewsLink 1.2

From Newsgroup: sci.electronics.repair

A quick way is to copy the column, then use Paste Special - Transpose. That flips the columns into rows instantly. If the data needs to stay linked to the original cells, the TRANSPOSE function can be a better option.
--
For full context, visit https://www.electrondepot.com/repair/excel-columbs-to-rows-4401297-.htm

--- Synchronet 3.22a-Linux NewsLink 1.2