How to parse form data using Excel Power Query

Landscape's Data Viewer gives you the ability to search for any work item where a certain form has been applied by querying on Form Responses; however, this limits the available columns in the results list to display the 'Question Asked' in one column, and the 'Value' in another. If you want to create a table with the questions as the column headers, this video shows you how to download the data and edit it in Microsoft Excel.


Note: If you already know that your form will only appear on one specific type of work item, there is a simpler way to do this without leaving Data Viewer: How to query on form data.


Still need help? Contact Us Contact Us