Wondering if there is a better/easier way to do this?
I have a table full of project data. These are connected to various high level collections. I am using rollups and lookups for a lot of this data to the Collections table. Many of these are rollups using the Unique array. However for some Lookups and Rollups that show all the data, I would really like to have identifier so it rolls up a list of the primary field + the data. For example recordA: $99.00, record B: $85.00
Right now to achieve this I need to duplicate many/mnost of my fields to creat a concatenation of primary field and the data I want, but I feel like this makes the base grow really large and would be cleaner/easier for everything if it can just do this in the rollup/lookup field directly?