PDF2XL Online Help

Create rows above column text

Here is an example for using the 'create rows above column text' layout type.

Consider the following table (already marked in the default 'create rows from text' type):

Note that the second column contain multiple lines of data per entry (due to line wrapping of the description). The desired results of the conversion is to have one record (or Excel row) per entry.

PDF2XL allows you to automatically combine the multiple lines of text into the correct cells. Using the 'Create rows above column text' on the first column, here is what we get:

As can be seen above, PDF2XL now groups all the data until it finds a text in the first column. When this occurs, a new row is started above the text.