Convert a vertical distance table to a matrix

[Jantje Beton]

Hello everyone,



I am pretty new to access and only used it once before, therefore I am trying to find an answer on this forum.

I received a distance table of 402 regions, with each its on regional code, to each other in driving time in minutes.
Thus in total 402x402=161,604 records.
However, all records are listed below each other (as in the attached picture), but I need it in a matrix form.

How do I do this? Thanks in advance.

[orange]

Why do you need a matrix?
What exactly is the application involved?
Do you have an Excel background?
The column names in your sample look the same. What does each mean?

Regions tend to be areas, whereas locations tend to be points. You can get driving distances between points/locations via Google Maps.

[Jantje Beton]

For my research I am performing regressions in StataSE13 which have to be geographically weighted, for which I need this distance table.
I received it as a MS Access file, thus I do not have an excel background.
I already got the driving distance, that is the last column.
The explanation next to the table was that those are the distance between 'regions' and they took the central place of each region.
The table goes down to record 161604, thus after each 402 time the same region, another region follows. The names are region names and the i.e. 1001000 are the regional codes.

[orange]

OK, so you were given the table and the table has distances between every area/centroid(approximate center of an area).

What exactly are you going to do with the data in simple terms?

[June7]

You want a mileage table/chart, like what you find in a road atlas?

Might be as simple as a CROSSTAB query.

However, queries are limited to 255 fields. Since there are 402 regions, I don't think Access can provide the output you want in a single chart. And printing 402 columns on single sheet of paper wouldn't be easy anyway, even if the header labels are rotated vertical.

If you want to provide db for analysis and testing, follow instructions at bottom of my post.