I have 16 tables with me in 2 sheets. (please refer attachment for your reference)
I am looking to convert all this table in the drop-down list in the following the order,
1) Metro or Non-metro
2) individual or family
3) Plan
5) Price & age
in the end, I am looking for to be matched.
What should be the right approach?
Hello Jay,
I an not sure that I have grasped fully what it is you want to do, for example, what is to be matched?
Any way, from what I understand this blog article comes close to what you want to do. If not, then please give more information about expected end result.
Hi Jay, do you want all the data in just one table to use that as a reference table or such?
Or do you want to have a kind of lookup through this data (which in my opinion is not possible in this setting, you have to transform some things for that).
What is the outcome of the action you want?
Frans
