troubleshooting Question

report format indentations

Avatar of Pau Lo
Pau Lo asked on
Microsoft OfficeMicrosoft Excel
2 Comments2 Solutions198 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
mvidas

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros