Home > Forum Home > Developing Business Administration Solutions > Importing Data from PDF Files > Getting row below headings | Share |
Forum Topic | Login |
Getting Row Below Headings | Rate this: (3/5 from 1 vote) |
Since the text search relies on the starting text and ending text, a row of data underneath column headings can be extracted by specifying the last heading as the start text and the first text below the row required as the end text. Rows of extracted data can be then transformed to columns via the 'Text to Columns' command in Excel. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Getting row below headings in the Excel Business Solutions Directory |