Power query Pivot data without using the 'Pivot' function

H, I have a two column table and I would like column A to = Headers and column B = Row names with a true / false structure,

I have done this via Pivot and have included this in the worksheet along with an excel solution,

I have got quite close, and have added one query 'AddColumn' which is giving me what I want but is only for one column and is very labour intsensive;

T

Please Login or Register  to view this content.

and this would need doin for each column, what I would like is to have "TableTransformColumn" rather than 'Add', but cannot get this to
work as above for either text.contains or list.contains.
so ;

Please Login or Register  to view this content.

returns an error, both text and list are show in steps 'containstext' and 'coluntolist' in the 'structure' query,

I have tried to label all steps to make it clear, I need some fresh ideas,

Richard.

Thanks, I have not had a chance to go through it, I have a few other things on the go at the moment,

I'll leave it open and see if I get any other suggestions, can't give you a rep, so best wishes to you and yours ( especially the Lab) for charismas and new year.

Richard