Creating a 2-dimensional array from a 1-dimensional list

Hello!

I've been a lurker on this forum for a long while and it's always been able to provide me with lots of excel tips, and for that I am grateful! But this

time I have a question that I can't find the answer to here, or anywhere else on the web after a few hours of looking.


As a note, I'm not very experienced with Excel, probably somewhere between novice and intermediate.


What I need to create is a 2-dimensional array of data. The vertical (y-axis) are the tools, and the horizontal (x-axis) are the jobs. Where the y-axis

and the x-axis intersect, will be the quantity of tools needed for that specific job. There are almost 1500 tools, and 100 jobs.

ex:

          job 1    job 2    job 3
tool 1      2                 4
tool 2               1
tool 3               5        3

What I have as a dataset is a 1-dimensional list, with columns for the tool, the job, and the quantity of tools required for the job. All the data is there, there is

a row for every time a tool is required for a job.

ex:

Tool      Job    Qty

tool 1   job 1    2
tool 1   job 3    4
tool 2   job 2    1
tool 3   job 2    5
tool 3   job 3    3

From what I've read, most of the time people go from 2-dimensional to 1-dimensional, using vlookup and match... But in my case I need to populate a

2-dimensional array from data in a 1-dimensional list.

I'm sure this is possible, but I don't know how I would go about it, and I'm not sure if my excel knowledge would allow me to figure it out even if I was

told how it could be done. Here's hoping!

Can anyone help? If you need to see the files I'm working with, send me a PM since it's proprietary work data.

Thank you!

Sebastien Benoit