Flatten or combine search results
Our database takes certain data points that in the UI are in one field and creates individual records so that when querying the database you will get 4 records for 1 core record. An example:
This example is one event in the console. In the Event Operation field, there would be a multi-line field that would have these two lines and there could be 100 lines. Is it possible to write a query that flattens this data to effectively create one for all entries that are identical and then group the lines that are not? We would want it to look something like this:
It could be separated by any delimiter, but I am not that great at SQL and would ask for direction on how to approach this, if it is possible. I know there is some functionality with GROUP BY, but I don't know if you can build an index for the results and do what I am asking.