I have a table with 4 columns: tagid, TimeStamp, intvalue, and floatvalue.
The tagid has four different types of data: LineRun, ScrapRun, Speed, and Length.
Each tagid has a value in either the column intvalue or floatvalue.
I would like to transpose the tagid into header and insert its corresponding value that associated with it.
How would you do this?
I spent several hours trying to do it but no luck!