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 thatspans multiple rows and columns to a database format (columnar).
The following example converts every four rows of data in a columnto four columns of data in a single row (similar to a database fieldand record layout). This scenario is similar to what you would do when youopen a worksheet or text file containing data in a mailing label format.
To see an example that converts data, follow these steps:
In a new worksheet enter the following data:
A1: Smith, John A2: 111 Pine St. A3: San Diego, CA A4 (555) 128-549 A5: Jones, Sue A6: 222 Oak Ln. A7: New York, NY A8: (555) 238-1845 A9: Anderson, Tom A10: 333 Cherry Ave. A11: Chicago, IL A12: (555) 581-4914