Hello,

I have an INI file that im trying to reformat. On Sheet 1 is the current structure of the ini file. I've trying to reformat the variables and to add the name found on the cell in Group Names. I've tried to filter out the cells based on the criteria i need but when i do Autofill to the last cell available on column A it concatenates to the empty rows an the rows that are comments or sections.

The expected outcome sheet shows how it should look once the macro is done. The format of the variables from #{Test} to {{ Test.Server1 }}. If the original variable has a "." in the name already it gets replaced with "_" as shown on line 6. The comments and the sections do not get anything done to them.

The Group Names page can vary from 3 to 9 names just depending on the project. But you can see the expected outcome should have a separate column with each Name provided.

Any suggestions on how to accomplish this?Concatenate Example.xlsx