Create New Row Data

[adhaputraa]

Hello guys, sorry for my poor English..

I don't know what case is this, but I have some case, I want to create a data from another table. On table A, I use OCR Model to get data list like this :

And from this data, I want to change it into new table or table B like this :

Can appsheet do that? Can somebody explain how to build a data like that?

Or Can AppSheet execute a command such as adding rows when we input the desired number of rows in Table A? Utilizing the existing data in Table A?

Thank you for your helps guys.

[scott192]

It is more likely a couple of spreadsheet copy/pastes to rearrange your data.  From what you have shown it is very simple to prepare the data.  Do the following:

Make a copy of the OCR results in a new sheet.
Select the first 5 columns of this data and copy them to a new sheet (gooddata)
Delete columns [number member 1] and [number name 1] from your OCR results copy
Select the 5 remaining columns (and all the rows) and copy/paste them to your new sheet (gooddata) at the bottom

You will now have a sheet (gooddata) with all of the rows from your OCR sheet split neatly the way you want.

Now go and delete the column headings from your second paste and generally tidy your new gooddata sheet.

Note, that it IS possible to do this using sheets formulas, but it may be overkill for what you are doing.

[adhaputraa]

If I'm using database, is there any formulas on appsheet that can provide that?

Of course it will be overkill if I do copy/paste like that, I tried to used some formula, behavior or automation to automated the copy/paste that you mention it. But still, I can't find it in appsheet.

[JPAlpano]

Ypuncan search the Action: Copy rows to another table using values from this row (not row level).

[adhaputraa]

What should I write in "Set these columns" ? A list or index?