MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Finding the End Of a Column and Adding Data To It?

I am new to Mac Numbers and am trying to make my first spreadsheet within it, so I ask for a little understanding if this question is not correctly formatted or if the answer is hiding somewhere else o the web. I am trying to get a column of data to be read which includes blanks and to compile from this data a second column which contains the data without blanks. I was trying to get it to read through the first columns data recognizing the blanks and the entered data and then adding to the end of the second column. This is important as the data will in the first column will be feed from else where and so the blanks and data will appear at different points along the column at different times.I can provide the spreadsheet if it makes the example any clearer. any help would be greatly appreciated.
Eoin Hunt

Comments: One Response to “Finding the End Of a Column and Adding Data To It?”

    12 years ago

    I would create a second column that contains either a 1 or a 0. Use a formula like =IF(B1="",1,0). Then sort by that second column. This puts all of the blanks together, but keeps the first column in order. Then delete the rows that are blank.

Comments Closed.