I have data that is all being put into one cell and I am trying to find a way
to "extract" pieces of the info into separate cells, much like the "text to
columns" function, but I need "text to rows"

the data is organized like this:

Weight:
25 lbs

Dim:
12 X 12 X 12

Color Red

All that info is in one cell, spaced exactly how you see it above.

I would like it to be split into separate cells like this
Wieght 25lbs -- Dim: 12 X 12 X 12 -- Color Red

Hope this makes sense to someone that has a solution