Unstacking a Stacked Excel Cell or Parsing Free-form Text to Generate Multiple Rows
We all run into some version of this: Excel table formatted to look nice, no thought given to analyzability.In the free-form text cell, it looks like this: m/d: text [alt+enter]
m/d: text [alt+enter]
m/d: text [alt+enter]
m/d: text [alt+enter]
...
m/d: text [alt+enter] When the data are exported to JMP, the cell gets collapsed into: m/d: text m/d: text m/d: text ... m/d: text.
I want to parse that long ...