TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

Simple Pivot Table
Create a simple pivot table where one column in the data becomes the column headers, one column becomes the row headers and another column is used to populate the values in the table.