Related tags:
excel + (10)

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

Do columnists write their own columns?
posted by Jagz-Mario on Oct 17, 2011 - 15 answers

I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
posted by thankyoumuchly on Sep 8, 2011 - 3 answers

How can I use a column in an excel sheet to automatically become the comments for a corresponding column? [more inside]
posted by rich on Aug 6, 2011 - 3 answers

In Excel 2007 can I use data in a column on one spreadsheet to automatically change the name of another spreadsheet in the same workbook? [more inside]
posted by Lentrohamsanin on May 10, 2011 - 2 answers

How can I reformat some rows into columns in Excel? [more inside]
posted by teg on Dec 6, 2010 - 14 answers

Can anyone tell me what the architectural or sculptural term is for these low, narrow columns with busts of deities or heroes on the tops of them? (Or tell me a good source for finding such a term when you have a picture, like this one, which was taken in Pompeii?)
posted by manos_frias on Dec 1, 2009 - 7 answers

How to remove content from table that is not in other column [more inside]
posted by tseo on Sep 18, 2009 - 4 answers

Web design panic! Wordpress theme (YAML + sandbox) implodes on impact with internet explorer [more inside]
posted by yuletide on Apr 21, 2009 - 11 answers

Is this a good way to solve the equal height columns problem in CSS? [more inside]
posted by dolca on Mar 15, 2009 - 32 answers

Editor for very large flat files? [more inside]
posted by ROU_Xenophobe on Feb 5, 2009 - 20 answers

Name. Tab. Phone number. This creates two columns. One for name and one for phone number, except--when someone has a really long name that goes past the tab setting and impinges on the phone number area. Is there some sort of tab setting that will make that long name wrap around, creating a second line within its own name area? For the record, I know I could use a table to do exactly this, but I'm reformatting a huge amount of text that is already laid out with tabs. Any advice for this poor sap who accepted the job? The text is in an InDesign document, but I can copy it to a word processor or anything that would do the trick. Thanks!
posted by largecorp on Jul 18, 2008 - 13 answers

My wife and I are looking to make our entertainment room look somewhat like an Opera house. Any ideas for procuring inexpensive-columns? [more inside]
posted by mincus on Apr 5, 2008 - 12 answers

How can I get Keynote '08 to print slides in more than one column? [more inside]
posted by 4ster on Jan 10, 2008 - 2 answers

Typographers of the world, help me! How does one get lines of type to line up precisely in a two-column format? [more inside]
posted by deadcowdan on Aug 27, 2007 - 12 answers

In Microsoft Word 2003, I'm trying to format a document so that there is both one-columned and two-columned text on the same page. Whenever I apply two columns to the text I want to be in two columns, it always shunts all that text to a new page, as if I had inserted a page break. What do to? [more inside]
posted by midatlanticwanderer on Jan 30, 2007 - 18 answers

How do I do multiple sets of multi-column divs w/ CSS inside other multi-column divs? More details in first comment. [more inside]
posted by Kickstart70 on Nov 28, 2006 - 9 answers

Excel / VBA help needed: moving data from multiple columns to a 2-column format [more inside]
posted by blag on Aug 17, 2006 - 9 answers

I have an Excel worksheet populated with data from columns A through IS. I’d like to hide columns but I am getting the following error: “Cannot shift objects off sheet.” Why? [more inside]
posted by phoenixc on Jun 19, 2006 - 5 answers

A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
posted by empyrean on Jun 6, 2006 - 6 answers

Using MS Excel 2002 (Win), my mom has managed to reverse the order of the columns at the top of the page (Z to A instead of the usual). _Not_ the actual cell entries, but the columns themselves appear in reverse order. She has no idea how/when she did it. [more inside]
posted by rexruff on Nov 11, 2005 - 3 answers

Occassionally found on the sidewalks of Seattle, and probably other cities, steel blue columns stand about three feet tall, bolted down to the concrete. About seven inches in diameter, they are topped with a cap one foot tall with a door in the side. A padlock keeps the door shut. What are these things? [more inside]
posted by tomharpel on Sep 18, 2004 - 17 answers