Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an excel spreadsheet that contains 2 separate tables one under the other . They are separated by a blank row. The top table has a permanent amount of rows (4 + headers). The structure of the spreadsheet cannot be changed.
I want to load them as 2 separate tables.
I can easily set the beginning of the dataload for the bottom table by setting the correct number in "header is x lines".
Is there a way to limit the amount of rows uploaded from the top table?
example:
| Properties | option 1 | Option 2 |
|---|---|---|
| size | 3 | 5 |
| weight | 30 | 30 |
| height | 1.5 | 2.3 |
| depth | 5 | 6 |
| Color Prices | Option 1 | Option 2 |
| Blue | 5$ | 10$ |
| Red | 6$ | 10$ |
| Yellow | 7$ | 10$ |
Excellent! I never noticed this before! thanks!