My Online Training Hub

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

Create a matrix table from values in columns|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / Create a matrix table from values in columns|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
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
Create a matrix table from values in columns
Avatar
GaryTibble
Christchurch
Member
Members
Level 0
Forum Posts: 25
Member Since:
September 26, 2016
sp_UserOfflineSmall Offline
1
May 23, 2018 - 8:33 am
sp_Permalink sp_Print

Hi

A colleague wants to take the combination of the values in SPC_Area_Name, SPC_Park_Name, Park Type (lookup) and return the value from SPC_Specialist_First_Name into a matrix. The result will return the name of the person responsible for a particular Park and Park Type.

Please refer to the attached spreadsheet TAB named Query for the data set.

Thanks for your help in advance.

Gary

Avatar
GaryTibble
Christchurch
Member
Members
Level 0
Forum Posts: 25
Member Since:
September 26, 2016
sp_UserOfflineSmall Offline
2
May 23, 2018 - 11:04 am
sp_Permalink sp_Print

Maybe this post should have been put into the General section. Is it possible to have it moved please?

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 873
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
3
May 24, 2018 - 4:49 am
sp_Permalink sp_Print

Hello,

I am really not sure if I understand correct, but attached file shows what I would do if I had such list.
Using a PivotTable is great for many scenarios.

Br,
Anders

Avatar
GaryTibble
Christchurch
Member
Members
Level 0
Forum Posts: 25
Member Since:
September 26, 2016
sp_UserOfflineSmall Offline
4
May 25, 2018 - 5:20 am
sp_Permalink sp_Print

Hello Anders

Thank you for your response.

I will take your spreadsheet to my colleague to see if it what they were after.

Kind Regards, Gary

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6352
Posts: 27779

 

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