Index match + loops
Posted: Tue Mar 22, 2022 12:53 pm
Hi I have built a program that scans through a table of countries and sectors. If the sector exists in the country the table shows a 1, otherwise a 0.
I now want to build a program that scans through the rows and columns of the table and depending on whether the entry is a 1 or a 0 I want to create a new variable using the column and row headers as unique identifiers. Any references on how I might be able to do this?
See below the table:
I now want to build a program that scans through the rows and columns of the table and depending on whether the entry is a 1 or a 0 I want to create a new variable using the column and row headers as unique identifiers. Any references on how I might be able to do this?
See below the table:
- Capture.PNG (43.89 KiB) Viewed 12968 times