Filter Assembler Level

J

jknapp

Employee Name Rate Assembler level
Dianne Lee 0.8 1
Erika Tucker 0.5 1
Erin Johnson 0.8 1
Jack Anderson 0.9 1
Jessie Simpson 0.5 1
Joey Strickland 0.7 1
John Smith 0.8 1
Josh Smalls 0.4 1
Nick McClanahan 0.6 1
Sara Timberlake 0.4 1
Steve Adams 0.7 1
Sue Jones 0.6 1
Tom Hansen 0.6 1
Tonya Roberts 0.3 1
Chris Watson 0.6 2
Jane Doe 1 2
Joe Olson 0.9 2
Megan Miller 0.8 2
Ashley Smythe 1 2
Tyler Vossberg 0.9 3


This is my table on sheet 1.

I would like to generate a table like this:

Assembler 1 Assembler 2 Assembler 3 Assembler 4
Dianne Lee Chris Watson Tyler Vossberg
Erika Tucker Jane Doe
Erin Johnson Joe Olson
Jack Anderson Megan Miller
Jessie Simpson Ashley Smythe
Joey Strickland
John Smith
Josh Smalls
Nick McClanahan
Sara Timberlake
Steve Adams
Sue Jones
Tom Hansen
Tonya Roberts


Any help would be appreciated.
 
Top