Issue with columns (only vendor responses appear)

[Syndicate_Admin]

Good

I am preparing a report, in which I have to reflect the responses of the suppliers to certain queries.

The queries are the rows and in the columns (among other data) the suppliers appear. I just want the answers linked to those queries to appear, and that providers that have null don't appear in the columns.

How do I do it?

[Anonymous · Accepted solution]

Hi, @Syndicate_Admin 

Maybe you can use unpivot column in Power Query.

I create a sample table:

Then transfore data. Select the column with the null value, and then Unpivot the selected column.

This automatically ignores null values. Here is my preview:

Finally select Apply and Close.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Thanks a lot. You've been a great help

[Syndicate_Admin]

Hello

Thank you. I've already tried that, but if I filter in each supplier "not blank", all the answers disappear.

[Anonymous]

Hi @Syndicate_Admin ,
You can apply filter on the queries as "not blank" in the filter panes and it will not show the providers having null queries.

Thanks,

Avantika

[Idrissshatila]

Hello @Syndicate_Admin ,

you can filter them out in Power query, so that the data with null values won't appear.

or you can do this in the filterpane where you unselect the null values.