excel columbs to rows

LibreOffice has the "transpose" function built in:

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

More of the same:

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

RL

rotate your monitor 90 degrees (ducking...)

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

You better . . .

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

RL

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"

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

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.