Tring to create a table based on row data from a query

Hi Greg

You have not described your problem very well, which is probably why noone else has responded.

Just describe your point of difficulty rather excpect helpers to build the whole projects for you. 😀😀😀

This is not a criticism. Just advice. You will get quicker and better answers if you keep things simple.  😍😍😍

I am not sure what you are attempting but try this ....

In Power Query use the mouse to select all columns right of "Site_Master.Site Number"
for example MK1, MK2, MK3 to 6TOP

then click Transform ON the top menu and Unpiviot Columns > Unpiviot Columns 

click on the Attribute column > Add columns > Extract > Fisrt Characters = 1

click on the Attribute column > Add columns > Extract > Range = 1 to 10

Click on the "First Characters" > Text Filters = 1,2,3,4,5,6

Close and apply the changes

Add a matrix visual to a blank canvas and drag the columns as follows

I trust you have basic Power BI skills to builld the rest of the report, now you know how to use UNPIVOT.

Leran more about unpivot here 

https://support.microsoft.com/en-gb/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

Please click the thumbs up and [accept solution] button