greatsharkhunt
New Member
- Joined
- Feb 23, 2011
- Messages
- 1
Hi - I'm cleaning up a list someone's been keeping in Word for years and have a problem I hope this forum can help solve.
the data is formated like this
BOLD Category
BOLD Subcategory
name
name
name
BOLD Subcategory
name
name
name
(empty row)
BOLD Category
BOLD Subcategory
name
name
...and so on.
And I need it like this:
name Category Subcategory
name Category Subcategory
If there's a way to do this in one quick swoop, thats ideal, but if I could even get all of the BOLD cells into their own column, I'd be able to do this by hand fairly quickly.
Any ideas? There's no way I'm the first person to run into this problem
thanks
the data is formated like this
BOLD Category
BOLD Subcategory
name
name
name
BOLD Subcategory
name
name
name
(empty row)
BOLD Category
BOLD Subcategory
name
name
...and so on.
And I need it like this:
name Category Subcategory
name Category Subcategory
If there's a way to do this in one quick swoop, thats ideal, but if I could even get all of the BOLD cells into their own column, I'd be able to do this by hand fairly quickly.
Any ideas? There's no way I'm the first person to run into this problem
thanks