grid from a table

[whosoever]

Good day,

I have an input data as xy coordinates and corresponding data, over 600 lines (25x25 square), example

Please Login or Register  to view this content.

Now I want to get a grid like

Please Login or Register  to view this content.

In any form: table, chart or anyting else.

Any simple solution for this?
Thanks a lot

[NBVC]

..see attached for a sample..

formula used:

Please Login or Register  to view this content.

adjust ranges to suit.

This is an array formula which must be confirmed with CTRL+SHIFT+ENTER keys instead of just ENTER... you need to do this everytime you revise the formula. The { } brackets will appear when successfully confirmed.

Then copy down and across.

P.S. you need to create the header row and header column, manually first.

[whosoever]

Thanks a lot!
I got it (took a while ).