Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy guys. I have a question. I have an excel file which looks something like this:
What i want to do is to create 3 tables in which I want to insert next values:
Table 1 is obtained by iterating through the first column from the excel file and will look lije this:
Table1:
Table2:
Column2_1
Table3:
All these 3 tables should be connected between them because I want to create a drill down through all three tables.
Ex:
Column2 - Column2_1 -Column2_1_1
-Column 2_1_1
-Column2_2 - Column2_2_1
- Column2_2_2.
Is there any way to accomplish this behavior?