Hi to everyone
I ve been reading https://www.mrexcel.com/forum/excel...adsheets.html?highlight=excel+table+relations
as i am trying to solve following
Assume having two sheets in same work book.
Sheet 1 contains table 1 with columns "Name" & "Group"
Sheet 2 contains table 2 with columns "Name" & "Market"
I need to get a new "table" with all 3 columns related correctly which means "Name" & "Group" & "Market"
I ve been searching around including you tube and found about how to add tables' relationships in order to use it when creating a pivot table.
The thing is, that the pivot i build does not have the structure i would like. I use "Name" as the Key
When building the pivot i choose "Name" & "Group" from table 1 and then "Market" from table 2
Till the point i have chosen "Name" & "Group" from table 1 it all looks like a nice simple pivot table. But when adding "Market" i get all entries of column "Market" to each of the other data
Is it possible to get what i would like through a pivot table like this? Is there something else i need to set up?
I think Access is capable of doing something like it cant excel do it too?
(excel 2007/2013)
I ve been reading https://www.mrexcel.com/forum/excel...adsheets.html?highlight=excel+table+relations
as i am trying to solve following
Assume having two sheets in same work book.
Sheet 1 contains table 1 with columns "Name" & "Group"
Sheet 2 contains table 2 with columns "Name" & "Market"
I need to get a new "table" with all 3 columns related correctly which means "Name" & "Group" & "Market"
I ve been searching around including you tube and found about how to add tables' relationships in order to use it when creating a pivot table.
The thing is, that the pivot i build does not have the structure i would like. I use "Name" as the Key
When building the pivot i choose "Name" & "Group" from table 1 and then "Market" from table 2
Till the point i have chosen "Name" & "Group" from table 1 it all looks like a nice simple pivot table. But when adding "Market" i get all entries of column "Market" to each of the other data
Is it possible to get what i would like through a pivot table like this? Is there something else i need to set up?
I think Access is capable of doing something like it cant excel do it too?
(excel 2007/2013)
