[Solved] Trying to clean up a table

[sdiebold]

I converted a pdf table into a spreadsheet, and some cells in the pdf table turned into multiple cells in the spreadsheet, stretched into extra rows. It looks like this

sample.jpg (5.41 KiB) Viewed 879 times

I don't think I can fix it, I just want to delete the extra rows. Is there any function I could use to say something like IF no data in A(n) delete row n?

[Lupp]

How shall I learn the relevant facts from that Image?
Need a sample as .pdf and as the .ods you made from it.
Need your explanation what you actually did to "convert".

[sdiebold]

I used a free program to convert. It did a bad job. I don't have money to buy a program that will do a better job

I'm trying to keep all the rows with data in the A column, and delete rows without data in the A column

[robleyd]

Select all your data; assuming your data starts at A1 - click in A1 and Ctrl-Shift-End
Data | Filter | Standard Filter
Field name Column A; Condition = ; Value -not empty- ; click More Options; Copy results to and select a place to copy (another sheet??)
Click OK

The results to keep will be placed where you selected and you can then do what you will with the original data.

Note; if you make a booboo, Ctrl-Z (undo) is your friend.

[sdiebold]

Works great. Thanks