Serialisation of data in columns.

[wertpol111]

Hello to all Appsheet users!
I am writing to ask you How to sort the data in the app so that by default rows 2,3,4,5 are for the product and rows 6,7,8,9 are for the manufacturer? e.g.
Instead of “manufacturer’s name” simply as “name”
Instead of product name simply as “name”.
The name is the same here and here, but I would like it to be clear that the first “name” is for the product and the second “name” is for the manufacturer?
Is it possible to segregate the data in this way, or is it impossible in Appsheet?
I am attaching a screen shot of my app in this topic.

Thank you in advance for your help.
Tom.

[Vincent_P]

Hello,

You can reorder your dataset (sheet or appsheet table) and regenerate your schema.

Or another way, because i don’t like to mix data, create a table product, create a table manufacturer and finally your table project with project id, product id and manufacturer id as ref