The pivoted column worked beautifully (THANKS!), but in your example, all three rows for Daniel wound up on the same single row, with the values for time in the pivoted columns. In mine, everything wound up in the right pivoted columns, but I still have 3 rows. The values I used for the pivoted column were text (not time) -- does this make a difference? How can I consolidate so that I only have one row for each "person" (using your example)?
Any way to combine Rows once column is pivoted?
The pivoted column worked beautifully (THANKS!), but in your example, all three rows for Daniel wound up on the same single row, with the values for time in the pivoted columns. In mine, everything wound up in the right pivoted columns, but I still have 3 rows. The values I used for the pivoted column were text (not time) -- does this make a difference? How can I consolidate so that I only have one row for each "person" (using your example)?