How to Group Assets by Category?

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

I am making a spreadsheet to keep track of my assets and I would like to group them by Category.

EVEONLINE.CHARACTER_ASSETS() returns an array or Assets.
To get the Category I need the Group Object for the Asset.
To get the Group Object for the Asset I need to call EVEONLINE.GROUP() with the Group ID.
To get the Group ID I need to access the Asset Type.

I cannot call EVEONLINE.GROUP() with my Group IDs because it does not accept arrays.

Is it even possible to get the Group for my Assets in a Spreadsheet that Updates Automatically?

2

GROUP + array support is somewhat difficult, since if it supports arrays it can output subarrays. i.e.

=EVEONLINE.GROUP(id).types formula would only return 1 cell.

I haven’t really had any good ideas how to solve this array support for things that can potentially output subarrays.
You might need to source a helper file with a static output of the CATEGORY with groups expanded, and use XLOOKUP against it.