Would it be best to save each 'system' in a row?
This should work, along with adding column names.

Would I be able to search ANY cell and display all systems that match, 1 system per row, or in sheets?
The basic control-F would allow you to search across all cells, but it might be cumbersome for such a large data set.

If you're familiar with SQL, OpsLab let's you import CSVs into a database - then you can search using SQL. From there, you can export the search results into a CSV file.


Can I 'nest' or 'hide' system information OR display system information in a more readable format after a search?
It sounds like this would require a macro for custom search that produces a new sheet with the results formatted that way. In OpsLab, you'd be able to query for an individual system.