Hello All,



I have a macro that creates a folder structure.
In column A I enter a Plan Number to create an upper level folder.
With Column B it creates sub-folders where the upper level folder name is added adjacent to the sub-folder name followed by various suffixes.
Currently I use a macro to insert three blank spaces between each entry in column A and I copy and paste four different concatenation formulas adjacent each text string in column A.

Is there a better way to achieve an output like that below?

I wasn't sure if I should initially repeat the PN string as a contiguous column, add the varying suffixes, convert the formulas to values then delete the last three PN strings so only the first row is a unique entry.
Then again maybe it could use/repeat the value in column A until it changes and start over again.

Any suggestions wouyld be appreciated.

Column A__|__Column B
PN09589___|__PN09589 - Calculations
__________|__PN09589 - Capacities
__________|__PN09589 - Correspondence
__________|__PN09589 - Inspections
PN09590___|__PN09590 - Calculations
__________|__PN09590 - Capacities
__________|__PN09590 - Correspondence
__________|__PN09590 - Inspections
PN09591___|__PN09591 - Calculations
__________|__PN09591 - Capacities
__________|__PN09591 - Correspondence
__________|__PN09591 - Inspections
PN09592___|__PN09592 - Calculations
__________|__PN09592 - Capacities
__________|__PN09592 - Correspondence
__________|__PN09592 - Inspections

Regards, Dave T