Hi I have an excel table that has water quality data for numerous sites in
about a dozen columns eg. pH, salinity, turbidity , to put it in a database I
need to cut and paste it so that for each of these parameters, the site name,
code and date/time is in the same row.
Eg. Now it is: Site Code Date/Time pH Turbidity Salinity
I would like:
Site Code Date/Time pH
Site Code Date/Time Turbidity
Site Code Date/Time Salinity
Any help would be very much appreciated.
Thanks.
Cheers,
Greg