Split multiple choice answers (MS Forms) to separate columns in Excel with Power Automate

383 Views Asked by At

It seems that this has already been explained but I'm pretty new to Power Automate and couldn't understand the answers...

I created a form with single choice and multiple choices questions and would like Power Automate to automatically split the answers into different columns. 

enter image description here

So far I have been able to break the string but Power Automate add rows instead of columns and I'm stuck!

enter image description here

Any tips please?

Many thanks, Mel

enter image description here

enter image description here

enter image description here

0

There are 0 best solutions below