search for: station_name1

...mns are: DATE and PRECIP values for each station listed in the header. I would like to transform the matrix into three columns (database like) to be able to load the data in the database. Here is the output I would like to get get it, number of rows = ncol x nrow. Output should look like this: STATION_NAME1 DATE PRECIP STATION_NAME1 DATE PRECIP STATION_NAME1 DATE PRECIP STATION_NAME1 DATE PRECIP . . . . STATION_NAME2 DATE PRECIP STATION_NAME2 DATE PRECIP STATION_NAME2 DATE PRECIP . . . STATION_NAME170 DATE PRECIP STATION_NAME170 DATE PRECIP STATION_NAME170 DATE PRECIP STATION_NAME170 DATE PRECIP STATI...