Text String and Containing specific data values

[rxd42562]

Hello. I have a project that I am working where I need to show only specific string of data from a column. I do not not want to filter, because I want to still see the other columns for thos e that do not meet logic. Those that do not meet the text string would simply not show or be "". Below is a sample of data and that which I want to be shown and for all others as stated should show "". Example from data, Column 2 should only show "MSKB # 3000483". Column 2 and 3 should only show "CISA ...". Column 23 should show both the "CISA..." and the "MSKB #..." data. 

[sevenhills]

Ronda, 

It is not clear what is the output. Check this video if this helps! https://www.youtube.com/watch?v=Tkqc5pOWAKY

If not, pls. do these: 1) paste the same data from excel here or give a pq snippet to begin with. Remove the key info before doing on this public forum. 2) do some mockup of the output you want to see

Anyone of us can help!

[rxd42562]

Thought I should correct the columns are rows and while this is a csv file, I am trying to do this in power bi