Article ID: 192357 - View products that this article applies to.
This article was previously published under Q192357
This article has been archived. It is offered "as is" and will no longer be updated.
In Microsoft Excel, you can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).
The following example converts every four rows of data in a column to four columns of data in a single row (similar to a database field and record layout). This scenario is similar to what you would do when you open a worksheet or text file containing data in a mailing label format.
ExampleTo see an example that converts data, follow these steps:
f_row = row number of this offset formula
f_col = column number of this offset formula
rows_in_set = number of rows which make one record of data
col_in_set = number of columns of data