title: VBA that copies rows into new sheet based on each row's cell contents (example included)
body: <p>So I'm hoping for some help to automate a process that will otherwise involve copying and editing some 10,000 rows.</p>
  
  <p>This is stuff relating to location data. Essentially, there are tons of these Master Rows but they do not have individual rows for Unit Numbers. I am hoping to get something to expand these into individual Unit Number rows based on what is in Column N. Column N is intended to follow a strict format of being a comma-seperated single cell list for each row.</p>
  
  <p>Below is an example from <strong>Sheet 1</strong> of what each row will have and needs to be expanded upon. Note that <strong>Column N</strong> is green and follows a consistent formatting and this will be the determinant for how many times these rows will each be expanded upon.</p>
  
  <p><a href="https://i.stack.imgur.com/aeUso.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aeUso.png" alt="Master Rows with User-Input Data in Col N"></a></p>
  
  <p>Below is <strong>Sheet 2</strong> and what I want the VBA to create from <strong>Sheet 1</strong>. You can see that each row has been expanded based on the contents of <strong>Column N</strong> from <strong>Sheet 1</strong>. 
  <a href="https://i.stack.imgur.com/rWR6G.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rWR6G.png" alt="Intended Result"></a></p>
  
  <p>Like I said, it is expected that this will involve some several thousand rows to create.</p>