How to Split a single cell into multiple rows and add another row
<p>I have a table that has two Columns. Date and Test Name.
What I would like to happen is that the string of text in one single cell be separated into multiple rows. In addition, I need the date to be associated with each set of text. I have tried text to columns and then transpose, but it can only handle 1 set of string at a time and not the entire data set. </p>

<p><a href="https://i.stack.imgur.com/mG68Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mG68Q.png" alt="enter image description here"></a></p>