Importing data — A second header row

Real spreadsheets often have two rows of headings. RowFold looks at row 2 as it reads each file, and a second header row is not imported as a record. • Units or a description under the names, such as “(date)”, “£” or “kg”, or the header row written twice. Row 1 names the columns and row 2 is left out. • Group headings over the names, usually from merged cells. When row 1 leaves half the columns or more without a name, or gives two columns the same name, the names are taken from row 2. Several headings in row 1 each go in front of the names under them, giving “Customer Name” and “Order Date”. A single cell in row 1 is a title for the sheet and is dropped.