I have a csv file of servers and the amount of data each one uses. I'd like to create a report that contains groups of servers that have a combined total storage of 500GB or less. I'm virutalizing these servers and need to fit them onto 500GB datastores.
The csv file looks like this:
I'm trying to group them so that I would end up with output like this:
Is there a way in powershell I could do a "do while" loop or maybe a way in excel that I could do this?