Forum Discussion
Solved
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 ...
1. Split column4 by delimiter
2. select columns 1,2 and 3, and then "unpivot other columns"
3. cleanup your headers
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