Table relation

Closed
TheMarcus Posts 3 Registration date Friday September 11, 2015 Status Member Last seen September 15, 2015 - Sep 15, 2015 at 04:55 AM
Hello,

Ok This is the scenario,

I've a excel sheet, with inside 2 sheet.

In sheet1 i've a table with some some datas. In the collum B there are some names, and in collum C there are some reference.

I'd like to create a table in sheet2 with the name in the collum B that has the correspondent data in the collum C.

Sheet1
B C
john doe1 Monday
john doe2 Thursday
john doe3 Monday
john doe4 Sunday


Sheet2

Monday
-----------
john doe1
john doe3


Thanks