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!