I have an Excel list which has a computer name field in column A and in Column B, C, D and beyond in each column it list a single specialist application name. Many Computer names do not have any specialist apps so there is nothing in B, C, D and some computer names have up to 12 or more specialist apps.
I would like to use VBA to provide me a new list on a new worksheet which lists on each row the computer name and each of its specialists apps as a separate record. E.G 3 computers as follows
Computer A has APP1, App2 and App3, Computer B as no Apps and Computer C has just App1. The output I am looking for written to a new sheet is
Computer A, App1,
Computer A, App2
Computer A, App3
Computer C, App1
The challenge I have is not knowing for each row how many elements my array should have and the best looping structure to use to populate the arrays and to write them back to the new sheet.
Any Suggestions would be most appreciated.
I would like to use VBA to provide me a new list on a new worksheet which lists on each row the computer name and each of its specialists apps as a separate record. E.G 3 computers as follows
Computer A has APP1, App2 and App3, Computer B as no Apps and Computer C has just App1. The output I am looking for written to a new sheet is
Computer A, App1,
Computer A, App2
Computer A, App3
Computer C, App1
The challenge I have is not knowing for each row how many elements my array should have and the best looping structure to use to populate the arrays and to write them back to the new sheet.
Any Suggestions would be most appreciated.