Paste Special Options Missing - English - Ask LibreOffice
Jul 16, 2025 · Hi @ LibreOffice Community For years I have been using LO Calc and have been used to copying a column of numbers and pasting them into another column which contains …
Libre Calc, How to convert a vertical line of data into horizontal …
Nov 3, 2023 · I need help to convert a vertical line of data in a row to columns. It involves about 60 items with 14 rows each, to 14 columns with 60 rows. which change daily. I will label and …
Making Rows for Horizontal Pasting Inside a Single Text Box?
Dec 16, 2021 · Data>Text to columns … [OK] In this special situation, it splits the text rows in separate rows rather than columns. Copy, Paste-Special with transpose option.
How do I convert rows into columns (or vice versa) in Calc?
Feb 1, 2014 · I have some data spread out in rows. Now I’ve entered it, I really would prefer to see it in columns. Is there a way to do this automatically in Calc (i.e., change a row …
How to transpose one column into multiple row - Ask LibreOffice
May 9, 2019 · Hey, I have a lot of numbers (25344) in one column and i want to transpose it into rows, where i want to start new row after every 8 number. How can i do this? Like ...
Import PDF table into Calc - English - Ask LibreOffice
Jun 18, 2024 · I have read a number of answers but am still confused. I have four column PDF table I want to put in Calc. Waht are the exact steps I need to use e.g. what application do I …
Paste special transpose function missing in 6.0.4
Jun 14, 2018 · Hi David. I have to transpose columns to rows. I made a trial and copied columns in CALC, transposed them and then I pasted back the row as unformatted text in Writer. Then …
Transpose sequences of rows into columns, ending with one row …
Feb 11, 2022 · Hello, I’ve searched in both the answers and the documentation, but I can’t find a reasonably automated procedure for this: I need to transpose rows, which belong together, …
How do I transpose information in a spreadsheet column to a row?
Apr 21, 2018 · Spreadsheet data all entered in a single column, imported from a document. How do I make that information appear in separate columns on a single row? In other words, how …
How to transpose multiple rows to 1 column - Ask LibreOffice
Mar 24, 2015 · I have a set of data 245 rows deep by 28 columns wide. I want to move each row of data into a single column where each row of data is then vertically stacked above ...