Input Multiple excel tables within one sheet

Question

Hi,

I have an excel file.

within the file, on the same sheet, I have a structure whereby different tables are stacked vertically on top of one another separated by a black row of cells.

HEADER for Table

Data

blank row

HEADER for Table

Data

blank row

etc….

Each table has the same number of columns with same names the only difference is the header and the number of rows.

how can I input these tables so that the tables are joined however are categorised by the Header they fall under?

for example:

column 1:

HEADER 1

HEADER 2

cjaneczko · Answer

How many tables are we talking about. If its not alot, one way to do it would be to use an input tool for each table and then use the range option and select the range that the table resides in. You can use a formula tool to create a field that has each header in it to sort them after joined. Then either use a Join Tool or Union tool to bring them back together.

KimLamNg · Answer

Can you provide some dummy data?