Multi-Row Formula for adding Names

[TS-User]

Hello,

please find attached my little case.

I try to attach the names of the product categories ( variable numbers of products for each product category) which i want to extract from the field "sub total product category".

Input:

Output:

Thank you!!

[patrick_digan · Accepted solution]

@TS-User Here is my quick solution using the Multi-Row tool. Let me know if that doesn't solve your problem!

[DataBlender · Accepted solution]

Hi @TS-User

I used record ID to reverse the order of the records, then multi-row to create the category.

[TS-User]

Thank you !