[Solved] Want to split data

Discuss the spreadsheet application

[Solved] Want to split data

Postby drp_61 » Sun Nov 22, 2020 6:41 am

I want to split data (which in one row and in one column) to other row where it is "," Sample file attached.
Is it possible ?
Attachments
sample_data.ods
(8.66 KiB) Downloaded 13 times
Last edited by MrProgrammer on Sun Nov 22, 2020 4:59 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
Libreoffice 6.4.7 windows 10 enterprise, 64 bit
drp_61
 
Posts: 64
Joined: Fri Feb 25, 2011 9:05 am

Re: Want to split data

Postby robleyd » Sun Nov 22, 2020 6:57 am

Data | Text to Columns; use comma as separator and " as text delimiter.

If you are opening this data from e.g. a CSV file, use the same settings when you import it and you won't need the Text to Columns.
 Edit: OP asked new question, so further discussion is in Want to split data, multiple rows
Original topic locked to prevent fragmentation of discussion. 
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.4.6.2 (SlackBuild for 6.4.6 by Eric Hameleers) - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3643
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 30 guests