Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,​ask:3,​meta:2,​projects:5,​jobs:5,​music:6,​irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this? [more inside]
posted by iamkimiam on Sep 21, 2012 - 7 answers

Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]
posted by frecklefaerie on Apr 6, 2012 - 7 answers

I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
posted by monocultured on May 17, 2009 - 7 answers

Which one is right, Google or Excel? [more inside]
posted by JDHarper on Apr 2, 2009 - 22 answers

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

I want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003. [more inside]
posted by Jacqueline on Oct 7, 2008 - 1 answer