Spreadsheet: 685609d1594110227-generate-entries-in-one-table-based-on-another-populating-tables-example2
Sheet: Sheet3

Table 1 |  |  |  |  |  |  | Table 2
Shortcut ID | Original ID | Area | Topic | Subtopic |  |  | [NAME] | Area | Topic | Subtopic | Statute
225519 | 225518 | Arbitration | Institutional and ad hoc arbitration | Understanding institutional and ad hoc arbitration |  |  | 177309 | Arbitration | Arbitration under the Arbitration Act 1996 | Interim and emergency measures | Arbitration Act 1996
224231 | 223784 | Arbitration | International arbitration | Costs in international arbitration |  |  | 210431 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Arbitration Act 1996
223957 | 90997 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law |  |  | 217591 | Arbitration | Arbitration under the Arbitration Act 1996 | The arbitration agreement | Contracts (Rights of Third Parties) Act 1999
223799 | 31319 | Arbitration | Arbitration under the Arbitration Act 1996 | Understanding arbitration under the Arbitration Act 1996 |  |  | 217591 | Arbitration | Arbitration under the Arbitration Act 1996 | The arbitration agreement | Arbitration Act 1996
223802 | 189230 | Arbitration | Arbitration under the Arbitration Act 1996 | Understanding arbitration under the Arbitration Act 1996 |  |  | 229979 | Arbitration | International arbitration | Conducting international arbitration | Arbitration Act 1996
225159 | 181753 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law |  |  | 270026 | Arbitration | Arbitration under the Arbitration Act 1996 | Starting an arbitration | Arbitration Act 1996
227560 | 227557 | Arbitration | Arbitration under the Arbitration Act 1996 | The award |  |  | 1372808 | Arbitration | Industry-specific arbitration | Maritime/Shipping | Arbitration Act 1996
225160 | 181753 | Arbitration | International arbitration | Jurisdiction and applicable laws |  |  | 1376714 | Arbitration | International arbitration | State immunity | State Immunity Act 1978
227558 | 227557 | Arbitration | Arbitration under the Arbitration Act 1996 | The tribunal |  |  | 1376772 | Arbitration | International arbitration | Arbitration in Asia | Arbitration Act 1996
225157 | 1404007 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law |  |  | 1404007 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | State Immunity Act 1978
225158 | 181565 | Arbitration | International arbitration | Jurisdiction and applicable laws |  |  | 1404007 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Civil Jurisdiction and Judgments Act 1982
227561 | 227557 | Arbitration | Arbitration under the Arbitration Act 1996 | Conducting the arbitration |  |  | 1404007 | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Arbitration (International Investment Disputes) Act 1966
232805 | 229958 | Arbitration | International arbitration | The tribunal |  |  | 1480061 | Arbitration | Arbitration under the Arbitration Act 1996 | The award | Arbitration Act 1996
233621 | 231956 | Arbitration | International arbitration | Arbitration in the Americas |  |  | 1568206 | Arbitration | International arbitration | Understanding international arbitration | Arbitration Act 1996
233620 | 74843 | Arbitration | International arbitration | Arbitration in Australasia |  |  | 158850 | Arbitration | Arbitration under the Arbitration Act 1996 | Starting an arbitration | Limitation Act 1980
233622 | 231957 | Arbitration | International arbitration | Arbitration in the Middle East |  |  | 158851 | Arbitration | Arbitration under the Arbitration Act 1996 | Starting an arbitration | Foreign Limitation Periods Act 1984
233638 | 1568206 | Arbitration | International arbitration | Costs in international arbitration |  |  | 158853 | Arbitration | Arbitration under the Arbitration Act 1996 | Starting an arbitration | Contracts (Rights of Third Parties) Act 1999
236473 | 184347 | Arbitration | Institutional and ad hoc arbitration | AAA arbitration |  |  | 158855 | Arbitration | Institutional and ad hoc arbitration | ICC arbitration | Limitation Act 1980
233640 | 189797 | Arbitration | International arbitration | Costs in international arbitration |  |  | 160086 | Arbitration | Arbitration under the Arbitration Act 1996 | Challenges and appeals | Arbitration Act 1996
236488 | 1404007 | Arbitration | Institutional and ad hoc arbitration | DIAC arbitration |  |  | 160086 | Arbitration | Arbitration under the Arbitration Act 1996 | Challenges and appeals | Agricultural Holdings Act 1986
233617 | 208481 | Arbitration | Industry-specific arbitration | Construction |  |  | 160087 | Arbitration | Arbitration under the Arbitration Act 1996 | Challenges and appeals | Human Rights Act 1998
232608 | 68697 | Arbitration | Institutional and ad hoc arbitration | CIETAC arbitration |  |  | 160087 | Arbitration | Arbitration under the Arbitration Act 1996 | Challenges and appeals | [Senior Courts Act 1981]
232567 | 188413 | Arbitration | International arbitration | Enforcing international arbitral awards |  |  | 160090 | Arbitration | Institutional and ad hoc arbitration | Understanding institutional and ad hoc arbitration | Arbitration Act 1996
236489 | 184347 | Arbitration | Institutional and ad hoc arbitration | CIETAC arbitration |  |  | 160092 | Arbitration | Arbitration under the Arbitration Act 1996 | Challenges and appeals | Carriage of Goods by Sea Act 1992
236151 | 227557 | Arbitration | Arbitration under the Arbitration Act 1996 | Enforcement
233642 | 181019 | Arbitration | International arbitration | Costs in international arbitration
236475 | 184347 | Arbitration | Institutional and ad hoc arbitration | SCC arbitration
233643 | 163882 | Arbitration | International arbitration | Costs in international arbitration
232705 | 174987 | Arbitration | International arbitration | The tribunal
 |  | Table 3 (Desired result)
 |  | Area | Topic | Subtopic | Statute
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | State Immunity Act 1978
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Civil Jurisdiction and Judgments Act 1982
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Arbitration (International Investment Disputes) Act 1966
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | State Immunity Act 1978
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Civil Jurisdiction and Judgments Act 1982
 |  | Arbitration | Arbitration under the Arbitration Act 1996 | Jurisdiction and applicable law | Arbitration (International Investment Disputes) Act 1966
 |  | Arbitration | Institutional and ad hoc arbitration | DIAC arbitration | State Immunity Act 1978
 |  | Arbitration | Institutional and ad hoc arbitration | DIAC arbitration | Civil Jurisdiction and Judgments Act 1982
 |  | Arbitration | Institutional and ad hoc arbitration | DIAC arbitration | Arbitration (International Investment Disputes) Act 1966