parse file horizontally instead of vertically

H

HTC

When I try to import my delimited file into Excel, it parses as
vertical file. I need it to import in horizontal or traditiona
database format.

Example of what I am getting:
Jane Doe
123 Main St
Anytown, PA 12345

Thank you for your help
 
D

Dave Peterson

The bad news is this is more complex than you would guess.

You'll have to answer some questions to get better replies:

1. How is your data arranged?

Is it always 3 lines (name/address/city,st,zip)
Or could the number of lines vary between people?

If it does vary, how do you know which group you're on--is there an empty cell
between each group?

And if the data varies, is it always:
name
address
city, st zip
(something else)
(another something else)

So that each row can be assigned to the correct column.

If you only have few entries, you may be able to do it manually by selecting
each group, edit|copy, select a cell in column B and edit|pastespecial,
Transpose).

(But if you have a long list (and a nice pattern), I wouldn't do it manually.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top