How to convert table data into a monthly grid

[rantanwang]

Hi i absolutely love excel but I'm self taught and am currently stuck and hoping i haven't bitten off more than i can chew. I have created an ms Form to capture meter readings. its in one drive so a master workbook updates with each new response. the form captures single responses for 4 regions each with multiple buildings and each building may have 1 or more meters, once 1 reading is captured the form submits and nedds to be refired to capture another reading. That's all good and works well enough. each column header in the table is a question section in the form. My trouble is collecting the table date and showing it in a monthly scenario for each meter. as it works currently if a reading is submitted for meter x in january it creates a record on a row. if another reading is submitted for meter x in february it goes onto the next row. there are roughly 100 meters so 100 line a month will be generated. essentially what i'm trying to do is fill a matrix 1 row for each meter with columns for region then meter name then a column for each month . I cant get a pivot table to show just the reading. Any ideas?? sadly working on a work laptop and cant install xl2bb. Any help very appreciated as im going nowhere fast.

Thanks in advance

 

[rantanwang]

Sorry, should collecting the table data not date.