Power Query doesn't show some items

[Hans Knudsen]

In the attached workbook I have 3 sheets named Input, d and Final.
Sheet Input is the source of the Power Query table in Sheet d.

I wonder why it is that Input rows 177:182 and row 202 are not shown in the PQ table.

One more question - is it possible to extend the code in Advanced Editor so that I can show something like indicated in sheet Final.
Text in the workbook is almost written exclusively in Danish because that is what I am using, but I do not think this should disturb seriously.

 

[AliGW]

These rows do not appear to have any X in the data that has been pivoted - blank rows will automatically be excluded.

 

[Hans Knudsen]

I should have seen that.
Thank you.

 

[Hans Knudsen]

I realize that there are inconsistences between column F in Input and the headings in sheet Final, row 5.

By the way - I have come to think that it might be easier to get the data into sheet Final via some SORT(UNIQUE(FILTER.... construction, but if you think PQ would be better I am still interested to hear your thoughts.

 

[p45cal]

What do you want to appear in the body of the table on the Final sheet?
A Count of something, or names (Navn?).

I realize that there are inconsistences between column F in Input and the headings in sheet Final, row 5.

So how should we group them? Like this (but it's not complete)?:

How to split Indsatspaedagog into flexindsats and familierettede inds?
What to do with Handvaerker?

Without grouping it could appear:

 

[Hans Knudsen]

@45pcal
Thank you very much that you will take a look.
I want names of Skole, Psykolog, Logopæd etc. to appear in the body of the table (sheet Final).
I attach a new workbook. As mentioned earlier there were some inconsistencies in the first one. I hope that this has been repaired in the present workbook. See also my comments in sheet d and sheet Final. Please forget about Håndværker. I have moved this item outside the Input table. Indsatspædagog should not be split, cf. headings in sheet Final.

 

[p45cal]

Something like the attached?
If so, all I did was to follow: https://www.mrexcel.com/excel-tips/pivot-table-with-text-in-values-area/

 

[Hans Knudsen]

Thank you very much p45cal and excuse me for my late response. I wasn't aware that you had answered.
Problem solved.