My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

You are here: Home / 16 table in to 1|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
16 table in to 1
Avatar
Jay Shukla

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
December 28, 2018
sp_UserOfflineSmall Offline
1
April 30, 2019 - 4:07 pm
sp_Permalink sp_Print sp_EditHistory

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?

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 871
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
2
May 1, 2019 - 4:57 pm
sp_Permalink sp_Print

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.

Avatar
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands

VIP
Members
Level 2
Forum Posts: 346
Member Since:
April 21, 2015
sp_UserOfflineSmall Offline
3
May 1, 2019 - 6:22 pm
sp_Permalink sp_Print

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

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: andria young, Bruce Tang Nian
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Bruce Tang Nian
Scot C
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27293

 

Member Stats:
Guest Posters: 49
Members: 31918
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen