Comparing two tables, Find Header and choose options

Hello,

I would like to compare two tables. One created by me where all possible table headers are collected in rows.

The second table is a random Excel data table loaded into the analytic platform.

I would like the program to compare Table 1 and Table 2 and recognize what data I am dealing with (using the header). Then send this data to another method of processing this data (depending on which data was read in)

Probably the main problem is that this data has a different number of columns and the header does not always have to be in the first row.

Table with collection header

| Nr | Column 1           | Column 2           | Column 3           | Column 4           | Column 5           |
| 1  | AAA1-ExampleHeader | AAA2-ExampleHeader | AAA3-ExampleHeader | AAA4-ExampleHeader |                    |
| 2  | BBB1-ExampleHeader | BBB2-ExampleHeader | BBB3-ExampleHeader |                    |                    |
| 3  | CCC1-ExampleHeader | CCC2-ExampleHeader | CCC3-ExampleHeader | CCC4-ExampleHeader | CCC5-ExampleHeader |
| 4  | DDD1-ExampleHeader | DDD2-ExampleHeader | DDD3-ExampleHeader | DDD4-ExampleHeader |                    |
|    |                    |                    |                    |                    |                    |

Example excel data table

| Column 1           | Column 2           | Column 3           | Column 4           |
| blablabla          |                    |                    |                    |
|                    |                    |                    |                    |
| DDD1-ExampleHeader | DDD2-ExampleHeader | DDD3-ExampleHeader | DDD4-ExampleHeader |
| Data-Column1A      | Data-Column2A      | Data-Column3A      | Data-Column4A      |
| Data-Column1B      | Data-Column2B      | Data-Column3B      | Data-Column4B      |
| Data-Column1C      | Data-Column2C      | Data-Column3C      | Data-Column4C      |

Thx for your replies.