How to transform Table using split function for below results?

ConfidenceOwl94 — Mon, 08 Dec 2025 01:27:35 GMT

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.

Re: How to transform Table using split function for below results?

txnelson — Mon, 08 Dec 2025 05:45:18 GMT

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