SOLVED

Split a column

Occasional Contributor

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!

 

 

1 Reply
Highlighted
Best Response confirmed by kaihendry (Occasional Contributor)
Solution

@kaihendry 

 

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.