Hi
We are in the early stages of a Windows 10 migration and are looking at compatibility for all installed software within our organization, prioritizing by applications with the most frequency. Our software management tool can report software installations by computer name, but it's done in a multi-line cell for each computer. I need a way to convert that multi-line information into rows, retaining the computer name for each installation (example pictured). That will allow me to get an instance count for each different software item in use. I realize I could do this via text to columns then transposing columns to rows, but that's far too labor intensive since there are thousands of lines. I'm hoping someone here has experienced something similar and can help out.
Thanks
Chris
Multi Lines to Rows.JPG
Bookmarks