Compare Variables from Single Column

[jpriemer]

Hello, 

I have a table with a single list of values and variable identifiers. Similar to the below. I want to be able to plot the any variable another by selecting the a single variable for my X and another for my y axis. Is it possible to do this simply my selecting which variable name I want on which axis? 

Variable Name	Value
Variable 1	528
Variable 1	528
Variable 1	528
Variable 1	528
Variable 2	345
Variable 2	345
Variable 2	345
Variable 2	345
Variable 3	5179
Variable 3	5179
Variable 3	5179
Variable 3	5179
Variable 4	52
Variable 4	52
Variable 4	52
Variable 4	52
Variable 5	645
Variable 5	645
Variable 5	645
Variable 5	645
Variable 6	4865
Variable 6	4865
Variable 6	4865
Variable 6	4865
Variable 7	354
Variable 7	354
Variable 7	354
Variable 7	354
Variable 8	183
Variable 8	183
Variable 8	183
Variable 8	183

[v-chuncz-msft · Accepted solution]

@jpriemer 

You may try Pivot Column in Query Editor.