| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy some text in columns and rest in rows
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate cell text FirstnameLastname into two columns | Excel Discussion (Misc queries) | |||
| Separate cell text FirstnameLastname into two columns | Excel Discussion (Misc queries) | |||
| Copy Text Only | Excel Worksheet Functions | |||
| special type of rows to columns procedure | New Users to Excel | |||
| Change rows to columns and vise versa | New Users to Excel | |||
Threaded Mode
