Forum Question: How Do I Split Individual Cells To Either Rows or Columns?

How do I split individual cells to either rows or columns in Numbers 5? I know that it was previously possible in Numbers ’09 . See Screenshot: https://drive.google.com/file/d/1NkVXKxaqW_dWoFNaf-3sjvmu4OHLPV_C/view?usp=sharing

Is there a way to do this kind of thing using AppleScript in the current version of Numbers? This is very useful in certain occasions.
—–
Myles Russell

Comments: 4 Responses to “How Do I Split Individual Cells To Either Rows or Columns?”

    8/2/18 @ 2:50 am

    You can definitely manipulate text in AppleScript or JXA in Numbers. But it takes some coding know-how. You may be able to find some starting points if you search online.

    But it may not take all that much effort. It depends on what you are dealing with. Numbers now has great options to import text into a table. See MacMostNumbers Text Import Options. So if have a situation with a whole table full of data in a single cell, or perhaps you imported it wrong the first time, you can always copy and paste the data into a TextEdit text document, save it, and then import it into Numbers.

    For other things, like a list of cells with first and last names combined, you may be able to use formulas to divide the text into two columns. But without specifics it is hard for me to advise further.

    Myles Russell
    8/2/18 @ 4:28 am

    Hi Gary, If you can see in older versions of iWork, there was an action that allowed you to split a single cell into either a row or a column as seen in the screenshot in on the first post. This makes it easier if you just want that particular cell to have another row under it or a column beside it. Currently, I just merge the adjacent cells one by one to get the same result which is very time consuming. I was hoping an AppleScript would help solve this for me.

    Myles Russell
    8/2/18 @ 4:30 am

    Also, I took some screenshots to explain what I wanted to do better:

    Split into Columns: https://drive.google.com/open?id=1bQw2180wm8FGAruvuuLSPkDJfJRF6b15

    Split into Rows: https://drive.google.com/file/d/1VgN8HdfBJoHZKPERazOL7EbCrA1afZr4/view?usp=sharing

    8/2/18 @ 9:46 am

    Myles: I don’t remember that function in old iWork. I wonder how it treated the cells, like if you split cell D7 what were the two halves called? As for you examples, why not just create a new column called “Notes” as it would do the same thing, right? You could always change the border styles on the cells to make it look the same as your old screen.

Leave a New Comment Related to "How Do I Split Individual Cells To Either Rows or Columns?"

:

:

:


0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)