I have an existing table (actually 50 different ones) I want to select data from. My columns headings are job numbers and row headings are states. Each job has 3 columns of data for it, although the job number only appears over the first columns.
I want my formula to pull the data in each job's third column into a new table where the column headings are the all the states, and the row headings are just certain jobs numbers which I have selected.
I've tried to nest vlookup/hlookup formulas to accomplish this, but having the data I want in a different column then the job number seems to be tripping me up. any thoughts?
Thanks
I want my formula to pull the data in each job's third column into a new table where the column headings are the all the states, and the row headings are just certain jobs numbers which I have selected.
I've tried to nest vlookup/hlookup formulas to accomplish this, but having the data I want in a different column then the job number seems to be tripping me up. any thoughts?
Thanks