Grouping Data by Rows in JMP Pro 18

[#1]

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 similarly for subsequent years—“Y2016”, “Y2017”, up to “Y2024”.

In addition, I would like to group the data based on the Location column. This should result in separate groups such as “Europe”, “America”, “Asia”, “Africa”, etc., depending on the regions represented in the data.

Could you please advise on how to perform both the year-wise and location-wise grouping in JMP Pro 18?

[#2]

Hello Jim. Thank you for your comments. However, I’d prefer not to have “Group 1,” “Group 2,” etc. appear as column entries. Instead, I’d like these groupings to be shown in the side panel. In your current illustration, the data are grouped by columns labeled “Location,” “RTBA,” and “CASH.” What I’m aiming for is a grouping where “Group 1,” “Group 2,” etc. are displayed in the side panel—organized by rows rather than columns.

[#3]

Here’s a clearer and more concise version of your message with a professional tone and refined flow:

---

Hi Jim,
I don’t see Group 1, Group 2, etc. listed in any column. I’d like these group labels to appear in the left side panel. In the screenshot you provided, the panel shows column-wise grouping—Location, RFBA, and CASH. Instead, I’m looking to group the data row-wise, where:

• Group 1 includes all 2015 entries (16 rows)
• Group 2 covers all 2016 entries
• …and so on, up to 2024

Is it possible to configure JMP Pro 18 to display this kind of row-wise grouping in the panel?

[#4]

The column panel on the left side of the data table only groups columns, not rows.  However, one can use a Data Filter to allow for the grouping of rows.  In my example I created a column called Group which had a value for each row....Group 1 for 2015, etc. I subsequently hid the column.  The data filter was then created, selecting upon column Group

.

[#5]

Hi Jim, I think your idea might just do the trick! I’ll test out the data filter you mentioned. Appreciate it!