Hi all

I have ceated an MS form to capture meter readings. the resulting spreadsheet containing responses creates a seperate line per response. I am trying to display all results for each meter x on 1 line and have the monthly readings appear on the same line ranging from left to right, jan, feb, mar etc etc. any help on how i can do this would be greatly appreciated.

Capture2.JPG