Skip to content
Advertisement

Select multiple values from a single underlying values as a table

I have a table from which I select multiple values based on two underlying values in the table

This returns a set of points

that I want to use to lookup corresponding values in another table

To do that however I need to convert this set of columns into a a single column

i.e.

This looks like I need to pivot the result but I cannot see how to. There are loads of (convert columns to rows answers but none seem to answer what I want.

Advertisement

Answer

You can repeat the cross apply:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement