To convert multiple lines in a saved search to a single row, use the NS_Concat() Function in Searches
The ns_concat() function loops through each instance of a summarized field, and returns an array of values that are comma-delimited. The result is then casted into a string. The example below shows the results tab of a case search that would return support reps, the number cases assigned to them, and a string containing a list of all the customers associated to those cases.
Solution
- Navigate to Lists > Search > Saved Searches > New
- Click Case
- Search Title: Enter a title
- Click Results
- Click Columns
- Follow the table below:
- Click Save & Run
Disclaimer: The NS_CONCAT function is not officially supported by NetSuite. Furthermore, result values for formula fields containing the NS_CONCAT function are limited to 4000 characters. Use this function at your own discretion.