I am on the latest Excel 365. How can I extract lines into separate rows? Some lines will have a different number of lines, Some for example will have 3, 2 or 1.
Book1 | |||
---|---|---|---|
A | |||
1 | Dog Cat Snake | ||
2 | Boat Car | ||
3 | House | ||
4 | |||
5 | What I like | ||
6 | |||
7 | Dog | ||
8 | Cat | ||
9 | Snake | ||
10 | Boat | ||
11 | Car | ||
12 | House | ||
Sheet1 |