I have multiple tables in an excel sheet and now I only want to extract that exact table So for that I am creating a flag column like below
I want to create a flag that starts from Default in column 1 and ends at total. Below is the example
Input:
| Trade Sheet | |||
| name | account | amount | rate |
| Alex | 123 | 456 | 0.23 |
| Grace | 456 | 251 | 0.12 |
| Total | 579 | 707 | 0.35 |
| Default | |||
| name | account | amount | rate |
| Alex | 123 | 456 | 0.23 |
| Tom | 45 | 45 | 0.68 |
| Total | 168 | 501 | 0.91 |
| Keep Sheet | |||
| name | account | amount | rate |
| Alex | 123 | 12 | 0.25 |
| Grace | 456 | 251 | 0.12 |
| Total | 579 | 263 | 0.37 |
Output:
| Flag | ||||
| 0 | ||||
| Trade Sheet | 0 | |||
| name | account | amount | rate | 0 |
| Alex | 123 | 456 | 0.23 | 0 |
| Grace | 456 | 251 | 0.12 | 0 |
| Total | 579 | 707 | 0.35 | 0 |
| 0 | ||||
| Default | 1 | |||
| name | account | amount | rate | 1 |
| Alex | 123 | 456 | 0.23 | 1 |
| Tom | 45 | 45 | 0.68 | 1 |
| Total | 168 | 501 | 0.91 | 1 |
| 0 | ||||
| 0 | ||||
| 0 | ||||
| Keep Sheet | 0 | |||
| name | account | amount | rate | 0 |
| Alex | 123 | 12 | 0.25 | 0 |
| Grace | 456 | 251 | 0.12 | 0 |
| Total | 579 | 263 | 0.37 | 0 |
If you will see 1 is only in the default table
@Sshasnk , Please check if this is what you needed. I have used Multi Field Row to achieve your result.

