Break a data set into multiple rows

Hello, I can do some basic stuff with VBA in Excel but I'm stuck on a process and hoping someone here might help.

I can create a one dimensional array of data a write it to a new row in and existing workbook. Here is the basic process:

Please Login or Register  to view this content.

The row single row of data looks like this:
Smith A1 B1 C1 A2 B2 C2 A3 B3 C3

This same process can be run again with a new set of data and the result could look like this:
Smith A1 B1 C1 A2 B2 C2 A3 B3 C3
Roberts A1 B1 C1 A2 B2 C2 A3 B3 C3

I need the data to look like this:
Smith A1 B1 C1
Smith A2 B2 C2
Smith A3 B3 C3
Roberts A1 B1 C1
Roberts A2 B2 C2
Roberts A3 B3 C3

My data set will always look the same. The source for each data set is a Word form where a named person inputs information sets about planned travel e.g., Trip A, Trip B and Trip C
I don't know if there is a function in Excel that I could run after the single rows are created or it would need to create and input a two dimensional array. If so, what code would I use to write the four data rows for each input.

Thank you.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

However, if you continue to not use code tags, you can expect to have your thread BLOCKED until you add them yourself.