Sum up some values into one row

[Lorithas]

Hi guys,

I want to take all Values from column P with the same Value in column A , and put them beside each other in one cell seperated with a , if there are more than one

So If A2,A3,A4 are the same, they will have different values in P2,P3,P4 (For example: P2= XABC P3=XDEF P4= XGHI. I then want to copy the tabel into a table2 and delete all duplicates for A. Then I want all Values of P for each (now unique a) into the row A so in this case: P2: XABC , XDEF , XGHI .


Here Is the table I am working with:

https://www.dropbox.com/s/3zpcb14e4b...ten0.xlsm?dl=0

So in spezific I want If InstrMainType ( A ) is the same as another InstrMainType ( A ) in the following 20 rows from Tabelle1 (german) , i want the Value in Tabelle2 to be all Excanges (Pīs) from Table 1 with the same InstrMainType ( A ).

I hope this was half comprehenseble .
If not, please ask me if something is not clear.

thx

phill

[tamthat]

Link error!

[FDibbins]

Lorithas welcome to the forum

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.