How to Split Columns in a Google Docs Spreadsheet. When you're working on a data set, you occasionally need to split a column into two or more new columns. For example, if you imported a database ...