http://office.microsoft.com/en-us/excel/download-microsoft-power-query-for-excel-FX104018616.aspx "Download Microsoft Power Query for Excel"

The three steps were:

1. Start with the Control worksheet table, then merge the Risk worksheet table to it. Then merge the Cycle worksheet table to that.

2. Expand the two Table columns

3. Delete the duplicate columns

The PowerQuery "formulas" for those three steps are:

```
Source = Table.AddJoinColumn(Merge1,{"Cycle Index", "Cycle Name"},()=>tbCycle,{"Cycle Index", "Cycle Name"},"NewColumn.1"),
#"Expand NewColumn" = Table.ExpandTableColumn(Source, "NewColumn", {"Cycle Index", "Cycle Name", "Risk Index", "Risk Number"}, {"NewColumn.Cycle Index", "NewColumn.Cycle Name", "NewColumn.Risk Index", "NewColumn.Risk Number"}),
#"Expand NewColumn.1" = Table.ExpandTableColumn(#"Expand NewColumn", "NewColumn.1", {"Cycle Index", "Cycle Name"}, {"NewColumn.1.Cycle Index", "NewColumn.1.Cycle Name"}),
RemovedColumns = Table.RemoveColumns(#"Expand NewColumn.1",{"NewColumn.Cycle Name", "NewColumn.Cycle Index", "NewColumn.1.Cycle Name", "NewColumn.1.Cycle Index"})
```

CreateRelationalTableQ28350514.xlsm