Forum Discussion
AdministratorIssue with columns (only vendor responses appear)
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?
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.
5 Replies
- Idrissshatila
Super User
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.
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
Syndicate_AdminHello
Thank you. I've already tried that, but if I filter in each supplier "not blank", all the answers disappear.
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
