I have been asked to take data from a Lotus Notes databse and put it into Excel. I have the data in Excel however the issues are as follows:
1. The data is a structured text file
2. the data comes into Excel with all of the headings in column A and the data in Column B
3. The data runs vertical in a repeating set
example:
<tbody>
</tbody><colgroup><col></colgroup>
1. The data is a structured text file
2. the data comes into Excel with all of the headings in column A and the data in Column B
3. The data runs vertical in a repeating set
example:
| FirstName |
| LastName |
| JobTitle |
| Department |
| CompanyName |
| BStreetAddress |
| OfficePhoneNumber |
| FaxNumber |
| MailAddress |
| StreetAddress |
| PhoneNumber |
| BPostfach_1 |
| BMainZipPOBox_1 |
| Type |
| FullName I understand I can used the Transpose command but the information repeats itself many times (vertically) and there are over 80,000 lines. What I am trying to do; 1. take the first set of information and turn it into column data in a seperate sheet 2. take all cooresponding data in column 2 (original sheet) and place it under the correct headers in sheet 2 I jsut don't have the chops for this one and would GREATLY appreciate any help at all as I have been at this for two days. Thanks in advance !!! |
<tbody>
</tbody><colgroup><col></colgroup>
