How to split a column according to 2 different data types

[stockmarket123]

Hi there

I am using Power query to transform a data set of different products (various alcohol brands).  However, Column 4 has 2 unique data sets: 1) Various Quarters in 2019, 2) Numerical Sales Margin by qtr.   

How can I split Column 4 into rows that will split both the various quarters in 2019 (Q1 2019, Q2 2019, etc) and 2) the margin ##'s into it's own separate column.  Please see 2 screenshow below.   the first screenshot shows the end desired result while The second screenshot shows what the original stock data set looks like.  Thank you.  I just need to know how to split the Column 4, I can figure everything else myself 

[lbendlin · Accepted solution]

1. Split column4 by delimiter

2. select columns 1,2 and 3, and then "unpivot other columns"

3. cleanup your headers

[stockmarket123]

yes.  this works perfectly!!.  thx