Input in pivot like form

Dear reader



I have a table like

DATE SOURCE MEASUREMENT

date1 sensor1 value

date1 sensor2 value

date2 sensor1 value

date2 sensor2 value

date3 sensor1 value

date3 sensor2 value

etc..



Has somebody a tip to create a pivot like input form with for example



SOURCE date1 date2 date3 ... date7

sensor1 value value value ... value

sensor2 value value value ... value



So that we can enter all the details for one week on one form

Thanks for thinking with me



Regards,



Ben

Input in pivot like form