help cleaning up raw data

[yourtwizted]

Hey guys,
So i have this reporting tool that only shows employees by supervisors and currently is not able to separate them by the LOB they are actually in
I am currently just looking for any way to organize or sort the RawData out and onto different sheets.
Unfortunately my company does not allow me to get to this site so i am on here trying to do this on my own time
the Raw Data gives the following information from Left to Right
Column A Column B Column C
Row 1 Employee Name Supervisor Name Aux Data
Row 2 jon a jon b hold
Row 3 larry a larry b on call
Row 4 ben a ben b ready



I have a list of supervisors for each LOB my goal is to have the raw data on 1 sheet, and for each LOB i would like to have 1 sheet dedicated to pulling data for only 1 LOB. Currently there are 3 LOB's and with potential for more to come in. currently the RawData pulls about 300 employees

Any ideas on how i can get this done? Pivot Table? VBA? Formulas?

 

[CA_Punit]

What is LOB by the way.

Please provide the List of Supervisiors in LOB1//LOB2//LOB3. I can seperate all the LOB's and provide the list of raw data on the basis of supervisor.

 

[yourtwizted]

LOB is Line of Business.
currently there are 32 supervisors. if you want to list it off i would just go with supervisor1, supervisor2, supervisor3
Due to contract with the client the most i can provide is the information i have provided so far.
the Raw Data comes in this format:

	Column A	Column B	Column C
Row 1	Employee Name	Supervisor Name	Aux Data
Row 2	Emp1	Sup2	Hold
Row 3	Emp2	Sup1	On Call
Row 4	Emp3	Sup4	Ready
Row 5	Emp4	Sup3	Not Ready

 

[CA_Punit]

How is a particular supervisor related to a particular lob

 

[yourtwizted]

They are only on a specific lob, they dont cover any others

 

[yourtwizted]

How is a particular supervisor related to a particular lob

They are only on a specific lob, they dont cover any others

Not sure if that answered your question

 

[CA_Punit]

What is your expected result as I am not able to understand your requirement.

 

[yourtwizted]

What is your expected result as I am not able to understand your requirement.

So I am wanting only employees under specific supervisors to appear on a sheet so if sheet1 is lob1 then employees with supervisors 1, 2 and 3 appear here. Meanwhile employees under supervisors a, b, and c are appearing on sheet2(lob2). All information is being pulled from a worksheet called rawdata