# Selecting a specific time on a list

I have a files with some precessed data for different locations and the data is organized by year, month hour - the hhour is either 00 or 12 UTC and I would like to split those data by year,month and time (00 or 12). I have tried some past posts on the subject but it has not worked. I have attached a xlxs file.

• Does data=SemanticImport["PBLHs.xlsx"] and data[GroupBy[#["Day Hour(12 UTC)"]["Year"] &]] work for you? – swish Jun 4 at 17:11
• It seems to do the trick, but how to plot those ? In as mentioned to #flinty this file has 3 separate sheets, corresponding to different locations. So applying this "sorting" on each sheets is easier to plot later.What was really bugging is the hour reference some subsets have, namely 00 and 1 which your code and his split apart. – user10737 Jun 5 at 0:36

data = Import["PBLHs.xlsx"];

• Change sheet1=Rest@data[[1]] to Flatten[data[[All, 2 ;;]], 1] to combine the sheets. The [[All, 2;;]] part skips the header row on each sheet. – flinty Jun 4 at 19:49