"Hide" column in matrix with no data

[CMSGuy]

I know this has been asked and answered, but I have not yet found a solution.  I have a matrix whose datasource is coming out of a datawarehouse.  The datawarehouse has 40 columns named Task1Name, Task2Name...Task40Name.  There are some instances where groups of data WILL use all of these Task columns, however most use much less and some use more than others.  Is there a way to NOT show, or hide, or not even select the columns in the Query, if there is not Name data for that field?

Thanks for the information

[mahoneypat · Accepted solution]

You should unpivot your data, so that your 40 column turn into two columns (task name and task value). You can then filter out any blank/null rows. In your matrix visual, you can use the task name column in the column field well to repivot your data showing only the columns that have data.

Pat

[CMSGuy]

So I would unpivot at the query level then?