Grouping Data by Rows in JMP Pro 18
I am currently working on a JMP Pro data file (attached), which contains 150 observations covering the years 2015 to 2024. The dataset comprises four columns: “YEAR”, “Location”, “ENT CAP”, and “NEP”.
I would like to organize the data by grouping all rows according to the values in the YEAR column. For example, all 16 rows corresponding to 2015 should be grouped under the label “Y2015”, and simila...