Reshaping data: what is the best way to aggregate rows of the same object into one row?
I have a table with more than a thousand rows. A row is an object that has 5 measurements associated with it at each event. An object may appear in multiple rows because of multiple measurements performed at different events, Here is what the table looks like. Alias column is the object name (the 19 objects seen here are unique, i.e, measured only once). What I need is a table where each row...