Hi experts,

I copied a table (in .pdf) with three-columns from an internet source. I simply highlighted all data (about 200 rows) and pasted it directly in MS Excel expecting to retain the three-column format in Excel. But the result was not as I expected.

The sample result is as shown in the attached file. There is a consistent row-gap for every data (See FROM THIS), though the first three data should have been displayed in a single row only, under the column : School, Code No., Tel. No. (See TO THIS output).



How then should the original three-column format be restored as shown in the attached file? Please note that the blank row-gap is consistent as a break for each data in the table.

Thanks,

Kim

Attached Files

Query105.xls (21.5 KB, 12 views)

If you don't have a professional tool like Abby fine reader, you can try this online tool, which will create an excel workbook; every table from uploaded PDF file is saved in a new worksheet, with almost no errors; then you can copy this table in your work (you will receive an email with your converted file)
http://www.pdftoexcelonline.com/