Join 3,572 readers in helping fund MetaFilter (Hide)

15 posts tagged with excel and table. (View popular tags)
Displaying 1 through 15 of 15. Subscribe:

Pivot table help for n00b

I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]
posted by Bretley on Sep 21, 2014 - 8 answers

Adventures in giant-CSV land

Hi, I have a .csv that exceeds the maximum number of rows that Excel can handle, and before I can import it into a geodatabase in ArcGIS, I need to make one small edit – I need to delete the first row. Is there any way to do this and resave the file (preferably in a format other than .csv) in a way that retains the rows unable to be loaded in Excel?
posted by avocet on May 9, 2013 - 20 answers

How to set up Indesign file for importing an editable Excel spreadsheet?

Wrangling Excel data in InDesign: When first creating a multi-page pricelist (which will need to be updated regularly), importing data from a 2000-odd row speadsheet, what should I be considering? [more inside]
posted by puffmoike on Oct 27, 2010 - 3 answers

Copying Word tables into Excel without splitting cells into multiple rows

I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
posted by Dasein on Oct 18, 2010 - 8 answers

HTML Table to Excel to CSV

I would like to take the information from this Wikipedia page (the HTML table parts) and dump it into Excel. I don't need the flags, I just need the latitude, longitude, city name and country. What's the easiest way of doing this? [more inside]
posted by jontyjago on Jul 10, 2010 - 7 answers

How do I get a CSV file to display properly?

I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out. [more inside]
posted by digitalprimate on Apr 13, 2010 - 7 answers

I have me an xls table, I do!

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

Adventures in Data Interoperability

How do I convert a large raster image into a table for analysis and manipulation? [more inside]
posted by agentofselection on Dec 14, 2008 - 9 answers

Can I make an Excel chart from only one column?

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]
posted by niles on Oct 20, 2008 - 7 answers

Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

Importing Excel spreadsheet data into to Word

How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
posted by lunchbox on Jul 6, 2008 - 7 answers

Excel-Filter - How do I randomly reorder an array?

Someone asked me if I could use Excel to take a table of information and put it into a new table randomly. Without thinking about it too hard I said "Yeah, I bet I could do that." Turns out I spoke too soon. [more inside]
posted by qldaddy on May 13, 2008 - 7 answers

Just a little bit of help with Access...

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted by dance on Nov 5, 2007 - 2 answers

Excel - Concatenate fields through Vlookup...or something

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]
posted by bwilms on Jun 9, 2006 - 10 answers

Pivot Table Charting Help

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]
posted by dantodd on Mar 30, 2006 - 4 answers

Page: 1