Dear all,
I am a beginner in Power Query. it seems very useful to a non coding guy like me. 
Here is my concern. I would like to get all values in a query into a unique column. It is summarized in the attached file.
Removing null and duplicates would be a plus; but i can tackle those after exporting the query.
Having the solution would be very useful to me; because i have hundreds of rows and columns.
With greetings
Julien
Hi Julien,
Pleas see attached file.
Note that the last step in the query is to filter the text string "null" from the merged column. This is because in the Excel sheet null is entered as text. If you are retrieving data from somewhere else and end up with null values you will need to modify the query to account for this.
Regards
Phil
