Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
99
Views
Topic starter
Hi
is it possible to split a row into 2 based on a table of %ages - if yes, how would I do this?
See attached workbook
Thanks
Posted : 05/01/2020 2:47 pm
Hi Alison,
Your file mentions a 'split table' but you haven't included it so I can't show you an example. However, in session 7.08 of the Power Query course I covered an example of using Power Query to split rows.
I hope that helps. If you're still stuck, please share the file again where you include the split table.
Mynda
Posted : 05/01/2020 6:03 pm
