My Online Training Hub

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

16 table in to 1|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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: 928
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
Haarlem - The Netherlands

VIP
Members
Level 2
Forum Posts: 349
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:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 928
Purfleet: 415
Hans Hallebeek: 352
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Rena Towles
Wim Verhaege
Shavirai Mawere
Macarena Verdugo
Linlin Reid
Francisco Barrera
Terry McAuliffe
Michel Richard
James Ramsey
M Aminul Islam
Forum Stats:
Groups: 3
Forums: 25
Topics: 7093
Posts: 31094

 

Member Stats:
Guest Posters: 49
Members: 34521
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen