Advanced delimit?

J

jmp14

New member
Joined
Oct 29, 2014
Messages
13
Reaction score
0
Points
0
Hey! How can I delimit a file but be able to create uniform columnvalues from data?
Change file from this:
cat;dog;bird
bird;dog;horse;cat
bird;cat;dog;horse
To this:
cat
 dog
 bird
 horse
cat
 dog
 bird
 horse
cat
 dog
 bird
 horse

Any help is greatly appreciated. I think there may be a formula that could work?
 
Data>Text To Columns
 
jmp14 said:
It's more than just delimiting the file. After delimiting, I need each unique entry to line up into it's own column, not scattered as it would be initally.
Click to expand...

The only thing I can think of so far is to review each column and make new columns with an IF function. . .if cell "A2" is cat then cat, if not than null. And then remove the nulls. . .
 
Hi,
is this help you ?
 

Attachments

  • Test.xlsx
    8.9 KB · Views: 5
You must log in or register to reply here.
Back
Top