Duplicate Values in a row to conver to columns

[markwefi]

Hi,
In the screenshot attached i have several rows that have more than one value.
I need to produce a single value for row 'a' and show all of the corresponding values in row 'b' horizontally.
For example in the attached screenshot there are 2 codes for AA005, namely 450050 and 450051.
I want to see in row 'a' AA005, row 'b' 450050 and row 'c' 450051.
Is there a way to make this happen?
Excel Example.jpg

[Special-K]

A detailed image is useless on this forum.
It creates delays and leads to solutions being offered as untested since noone wants to type the data in for you.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

[CK76]

Since you have Office 365, you have Get & Transform (formerly PowerQuery).

Select entire data (or if it's Excel table, any cell in table range).

Go to Data tab and select "From Table".

Once data is loaded to PQ editor, highlight [Group1] column and Right click, select Fill->Down

Select

Please Login or Register  to view this content.

EDIT: Remove single quote from Code. It's added so that it's not confused with tag.
Select the newly added column and right click. Split column -> By deliminter. Use comma as delimiter.

Remove the Aggregate column (shows Table as value), and rename columns as needed.

Load the table to new sheet. See attached sample.

[markwefi]

brilliant, thanks CK76 that works perfectly.
Apologies Special K, in future i will attach the relevant editable document.