Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There is a simple approach. It sounds like you are mostly trying to remove duplicates—you mention unneeded, identical rows. All you have to do is:

  1. Select the data you need to remove. Or just click anywhere within the data—don't bother working to select the whole data range; if it's contiguous (no gaps), Calc will figure it out automatically.
  2. On the menu bar, go to Data -> Filter -> Standard Filter...
  3. The default criteria will show "Field name" [whatever the column heading is], "condition" as equals, and "value" blank. Choose "not empty" for the value so everything in your grid will match the criteria.
  4. Click the "More options" button near the bottom.
  5. Check the "No duplication" box.
  6. Check the "Copy results to..." box, and choose where you want the de-duped list to be copied to.
  7. Click "OK".

If the original spreadsheet had typos in it you still might have some extra rows, like a row for "Zebras" and an extra one for "Zebars", but it should be a small number of them if any and you can remove those manually.