Power Query List Split with 2 Examples

[@ganeshacharya4918]

Hello Lineth Thank you

[@kirinde]

Hi Lineth, superb trick and wonderfully explained. Thank you so much!😇 Example 1 was what I was looking for

[@LinethDelaCruz]

Glad it was helpful!

[@wayneedmondson1065]

Hi Lineth. Such an awesome trick! In the past, I've done column unstacking by adding index columns, modulo, then Pivot and have to remove columns and rename. List.Split and the steps you demonstrated are much shorter. Thanks for sharing how to do this. Will definitely use in the future :)) Thumbs up!!

[@LinethDelaCruz]

Thanks Wayne!

[@zahoorsarbandi2982]

very helpful.. Thanks

[@Sumanth1601]

Excellent 😊👍

[@NP-kk6zv]

Thanks !

[@ExcelInstructor]

Hi Lineth 4:05

[@abdullah_alhathloul_]

Nice

[@vashisht1]

Can you please let me know why you use Square bracket in sales and not ( ) or { } ,,,,,,,,list.split (source [ Sales] , n)