Forum Discussion
How to split a column according to 2 different data types
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
1. Split column4 by delimiter
2. select columns 1,2 and 3, and then "unpivot other columns"
3. cleanup your headers
2 Replies
1. Split column4 by delimiter
2. select columns 1,2 and 3, and then "unpivot other columns"
3. cleanup your headers
yes. this works perfectly!!. thx
