Max value

Hello   I have some data, where I want to retrieve the max value from an unpivoted column. I need to retrieve the max value for each "name".  I have multiple record for each name, on different date...