Vlookup Data Scrambled.

Good Evening

I have a large amount of data from a client that I need to unscramble, I have attached a screenshot of a simplified sample version of what I am looking at.

Capture.PNG

What I am wanting to do is to Put all the P-001, etc references down a column (that is my line identifier) for the A, B, C references across the top and create a grid. The reason for this is because some references are missing in the source information, ie 1 line has information for A, B, C, E (D is missing), whilst another line only has A, B, F. The problem is there are no gaps as the source info is a CSV and there is no accommodation made in the file for the missing values, they are just not there.

So I need to sort out the information so all the data is kept together. in a grid and I am comparing apples to apples on a per line basis.

The information I received is about 500 lines down and probably 32 columns across. In previous years I have manually sorted it (and I felt my brain cells die as I did it). I think the answer lies between index, match, offset and a vlookup - but I have been wracking my brain for a while now and all I have gotten is a headache.

I have attached an excel file with the simplified source information in 1 tab and the grid pattern of how I would like it.

Any help would be much appreciated.

Thanks.

Put this formula in cell C4 of the Result sheet:

=IFERROR(INDEX(Source!$C$3:$N$27,MATCH($B4,Source!$B$3:$B$27,0),MATCH(C$3,Source!$C3:$N3,0)+1),"")

Then copy across and down.

Hope this helps.

Pete

You, sir, are an absolute saviour.

Thank you.

Glad to help, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Pete