filter data based on row value(text) ?
3 views (last 30 days)
I had data similar to shown in image1 and want to exteract data for all data for first column for all rows like image2, image3.....so on for all individual routes of column one.
how to filter data based on text values. Sample data is attached in excel file
Here is further followup question after this,
if first column has time varying throughout the day time of 24hr then how can I distribute this data with probability distribution having probality in night is higher during 10PM to 5AM and low in day time.