I have received a word document in format
group 1
member 1
member 2
member 3
group 2
member 1
member 2
memeber 3
Its proving hard to do analysis, I would like to autofilter for say all members of group 1. Is there anyway to import this data into excel so it would be like
group members
--------------------------
1 member 1
1 member 2
1 member 3
2 member 1
2 member 2
2 member 3
I cant see how on earth to format it in this way. From what i can see the indent is 3 characters.