Moving multiple data from one cell (Vertically) to another cell (Horizontally)

I am very green on using macros and am requesting some help, if it even needs a macro. I have an excel sheet that looks similar to the below, where I have a persons name listed numerous times in Column A and B. Sometimes a person is listed once, sometimes they are listed 6 times with different entries. In the next columns are some random registration and product information. I am trying to consolidate to one horizontal row with all of this information for each person, instead of multiple vertical rows.


Excel example 1.jpg

As an example, I am trying to get to something like this. Of course, since there are 6 entries for the person above, I would want Product name and Product Code to extend on the top row all the way through the #6. Basically, trying to get to one line for each person, with all of their choices.

Excel example 2.jpg

Any ideas on how this could be accomplished?

Thanks in advance.

Hello pzickert,

Welcome to the Forum!

While a picture is good, the workbook is better. People are not inclined to recreate your tables from a picture. Posting a workbook will provide you with faster response and a working solution.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Pic