How to transform Table using split function for below results?

[#1]

How can I convert left side table to looks like to right side one.

Below is the closest I was able to get with Split function. 

[#2 · Accepted solution]

Create a new column with the following formula

Col Cumulative Sum( 1, :ShopOrderId, :SN, :Material )

Then Split using the following setup

Then after the split, delete the formula column, in my example, delete Column 6