Pivot table plotting results from multiple rows on the same row- jan , feb , mar etc

[rantanwang]

Hi, I have a sheet that collects meter readings but each entry goes onto a separate line. The problem is I want to convert the data into a dashboard but I can't even get the pivot table to show the data in the type of tabular format I'm after. Assuming that's my best option? or maybe a vlookup per meter but I couldn't get that to work either) The Meter name is repeated on each line each with a new reading for that month, but I want to just show a table with the meter listed once and each months reading in a separate monthly column to the right. The data is populated by an MS form that the engineers run each month. It's in the very early stage but I want to get it right Help!

Energy Readings 1.xlsx
	BJ
13
Form1