Advanced INDEX MATCH (I think)

This is a fairly easy exercise using Power Query/Get and Transform. Here is the Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Email", type text}, {"Choice 1", type text}, {"Choice 2", type text}, {"Choice 3", type text}, {"Choice 4", type text}, {"Choice 5", type text}, {"Choice 6", type text}, {"Choice 7", type text}, {"Choice 8", type text}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Email"}, "Attribute", "Value"),
    #"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Attribute"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Value", "Email"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Reordered Columns", "Value", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"Value.1", "Value.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Value.1", type text}, {"Value.2", Int64.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type1",{{"Value.2", Order.Ascending}}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Sorted Rows", {{"Value.2", type text}}, "en-US"),{"Value.1", "Value.2"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Topic")
in
    #"Merged Columns"

The steps involved:
1. Load data to PQ
2. Unpivot all columns except first
3. Split Topic Column into two columns
4. Sort numeric column of split
5. Merge two columns
6. Delete unneeded columns
7. Close and Load to Excel Workbook.

Hayden
This is not very difficult. You will be surprised at how easy it is to learn and how efficient it is at manipulating data. Grab the book M is for (Data) Monkey and you will be doing amazing things in a very short time.