Hi there,
I need support on the challenge design below:
I need to limit my data to 10,000 rows per tab in Excel. Here's an example:
If I have 5,000 rows for Tag 1 and 5,000 rows for Tag 2, I will have only one output tab in Excel, as the total number of rows equals 10,000.
However, if I have 3,000 rows for Tag 1 and 9,000 rows for Tag 2, I will need two output tabs in Excel. This is because the combined total exceeds the 10,000-row limit for a single tab.
I cannot split the data such that 3,000 rows of Tag 1 and 7,000 rows of Tag 2 are in one tab, leaving 2,000 rows of Tag 2 in a second tab. In this scenario, all 9,000 rows of Tag 2 should be placed in the second tab. It is important to ensure that data for each tag is kept together and not partially split across multiple tabs.
Thank you for your help.
| Tag | data 1 | data 2 | data 3 | data 4 | data 5 |
| 1 | data | data | data | data | data |
| 2 | data | data | data | data | data |
More example:
| more example: | | | |
| | Tag | Rowcount | Tab Number in Excel |
| | 1 | 3000 | 1 |
| | 2 | 9000 | 2 |
| | 3 | 2000 | 3 |
| | 4 | 4000 | 3 |
