Hi,
I have two sheets in a excel file.(S1 & S2). Both common column say EmpID<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
S1 has EmpID and Fname<o></o>
S2 has EmpID and Locations, each EmpID has multiple Locations. The Empid of S1 have some common values of S2..<o></o>
<o> </o>
I need to merger these two sheets based on Empid, which displays Empid(of S1) and and its Locations from S2.<o></o>
<o> </o>
I tried using VLOOKUP() but its takes only single value of Locations. <o></o>
<o> </o>
Please help me out<o></o>
<o> </o>
Thanks in advance.<o></o>
I have two sheets in a excel file.(S1 & S2). Both common column say EmpID<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
S1 has EmpID and Fname<o></o>
S2 has EmpID and Locations, each EmpID has multiple Locations. The Empid of S1 have some common values of S2..<o></o>
<o> </o>
I need to merger these two sheets based on Empid, which displays Empid(of S1) and and its Locations from S2.<o></o>
<o> </o>
I tried using VLOOKUP() but its takes only single value of Locations. <o></o>
<o> </o>
Please help me out<o></o>
<o> </o>
Thanks in advance.<o></o>