Jun 27 2020 08:52 AM
I have a column with a value foo,bar, and I want it split into another row. https://s.natalian.org/2020-06-26/calc-workload.mp4 is a sceencast showing what I want.
Before:
two foo,bar 10
After:
two foo 10
two bar 10
How can I achieve that? Thank you!
Jun 27 2020 10:31 AM - edited Jun 27 2020 10:32 AM
Solution
You can use Power Query to transform the data and create the Pivot Table as desired.
Please watch this video demo (though without an audio, it would be easy for you to follow it) to know how you can do this.
Jun 27 2020 10:31 AM - edited Jun 27 2020 10:32 AM
Solution
You can use Power Query to transform the data and create the Pivot Table as desired.
Please watch this video demo (though without an audio, it would be easy for you to follow it) to know how you can do this.