General discussion on OpenOffice Calc and its spreadsheets.
Is it possible to force csv file data to be placed in a single column of many rows instead of a single row with
many columns or do I need to manually reconstruct my csv file one item per line and then open in calc ?
Thanks in advance,
Ricky G. Marion
- Posts: 25
- Joined: Mon Mar 24, 2014 6:33 am
When the data have placed into the Calc table, then you can transpose x/y coordinates of a cell range by usage of "paste special" option. (You can transpose a two dimensional matrix in a Calc document.)
Cut (Ctrl-X) the cellrange, select the Start-cell, and then:
Edit - Paste Special - Options: transpose (and you can adjust all other desired properties) - OK
- Posts: 24
- Joined: Tue Mar 25, 2014 6:30 am
Return to OpenOffice.org Calc
Who is online
Users browsing this forum: No registered users and 2 guests