I need to know how to pull job information from a list of jobs in multiple
columns.
Heres what I have.
A B C D E F G
H I
job type hrs job type hrs job
type hrs
Lasata r 8 Lasata r 8 Herald r
8
Lasata sm 6 Herald sm 7 Joe's r
7
Herald r 8 Joe's s 8 Joe's
sm 8
Joe's sm 7 Lasata fr 6 Lasata s
8
and so on....

I would like to start a worksheet that I can insert a job name in a certain
cell and the info for that job would go into a list.
Like this.

Lasata Herald Joe's
r 8 r 8 sm 7
sm 6 sm 7 s 8
r 8 r 8 r 7
fr 6 sm 8
s 8

Please help.