This article was previously published under Q116289
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article 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