Grouping of product

[123love55448]

Input

Order number	Product	Quantity
1	A	2
1	B	1
2	A	3
3	B	4
3	A	5
3	C	2

Output 

Order Number	First SKU	Quantity	Second SKU	Quantity	Third SKU	Quantity
1	A	2	B	1
2	A	3
3	B	4	A	5	C	2

Very appreciated all helps

[RobertZiegl]

I would solve it with getting a row number for each product in the order, and then use the cross-tab with the row number as new columns.

Cool small use case!

[Qiu]

@123love55448 
This can be done by Tile too;
I also use a Find and Replace tool to be a bit more dynamic for the new column names.

[flying008]

Hi,@123love55448 

Dear, if you have few columns to group, there is a easy way:

The key point here is that the conversion of numbers and words corresponds. If you add a corresponding table, there will be no problem with more  rows / columns.

Dynamic Rename Expression:

Switch(Tonumber(Left(Replace([_CurrentField_],"Column_",""), 1)),"Zero",1,"First",2,"Second",3,"Third",4,"Fourth") + Substring(Replace([_CurrentField_],"Product", "SKU"),8,20)

*******

Please mark this as the solution if it answers your question, it will help others to find solutions quicker.

[Qiu]

@flying008 
Nice one with the Make Columns tools.

[flying008]

Hi, @Qiu 

Dear, thank you !  If the dynamic rename tool support part dynamic replace mode, the case will be more easy for many rows/columns.