Hello! I am brand new to the forum. I am an Access and SQL user who needs to convert some SQL data I queried into an Excel 2007 spreadsheet. The data I pulled looks like this:

Login Lastname Firstname SkillName
1030 T1030 ESPINOZA LORI Abilene
1030 T1030 ESPINOZA LORI Anderson
1030 T1030 ESPINOZA LORI Corpus
1030 T1030 ESPINOZA LORI Evansville
1030 T1030 ESPINOZA LORI Kitsap
1030 T1030 ESPINOZA LORI Naples
1030 T1030 ESPINOZA LORI Redding
1030 T1030 ESPINOZA LORI SanAngelo
1030 T1030 ESPINOZA LORI Treasure Coast
1030 T1030 ESPINOZA LORI Ventura
1030 T1030 ESPINOZA LORI Wichita
1031 T1031 PIERCE LAURIE Abilene
1031 T1031 PIERCE LAURIE Anderson
1031 T1031 PIERCE LAURIE Corpus
1031 T1031 PIERCE LAURIE Kitsap
1031 T1031 PIERCE LAURIE Naples
1031 T1031 PIERCE LAURIE Redding
1031 T1031 PIERCE LAURIE SanAngelo
1031 T1031 PIERCE LAURIE Treasure Coast
1031 T1031 PIERCE LAURIE Ventura
1031 T1031 PIERCE LAURIE Ventura Special
1031 T1031 PIERCE LAURIE Wichita
1032 T1032 THOMPSON KELLI Abilene
1032 T1032 THOMPSON KELLI Anderson
1032 T1032 THOMPSON KELLI Corpus
1032 T1032 THOMPSON KELLI Evansville
1032 T1032 THOMPSON KELLI Kitsap
1032 T1032 THOMPSON KELLI Naples


And I need it to look like this:

REP / SKILL SET BY PAPER NAPLES ABILENE ANDERSON BOULDER CORPUS EVANSVILLE

REP ID# NAME
901197 HENAGE, KENNY x x x x
901201 BALTIER, NARCISO x x x
901541 GRAHAM, JANE x x x
901938 ROMERO, MARIA x x x x
901943 FLORY, BEATRICE x x x

Any suggestions? I know very little about VBA and macros, I'm sorry to say.
Any help would be great! Thank you, Michele p.s. when I preview this post, it is not showing the "x"'s under the paper names. I can attach the Exel file if would make more sense...