Solution
table widget
Guide
Building a Table with Row Grouping, using Variable Mutations
Read more about Building a Table with Row Grouping, using Variable MutationsTutorial
Using Javascript Mutation to Create and Use Variables in Appsmith
Read more about Using Javascript Mutation to Create and Use Variables in AppsmithGuide