# Tagged Questions

**-1**

votes

**0**answers

17 views

### Split apart and remove data in Excel 2007

I receive orders for telephone service for between 15 and 30 stores in a single email in regular text format. The stores are separated in the email by one blank line. Each store begins with ...

**0**

votes

**1**answer

49 views

### Formula works in excel and not in Google Spreadsheet

The following formula works in Excel but not in Google Spreadsheet:
=INDEX(Sheet1!B1:P1,MATCH(MAXA(Sheet1!B11:P11), Sheet1!B11:P11,0))
Would there be alternatives?
Thanks,
Bing

**2**

votes

**5**answers

5k views

### In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells?

I work with all three spreadsheet programs listed above, and I believe my question can be answered the same or similarly for all three.
On my sheet, I have a top row full of column headers. The ...