List of Unique Values from Multiple Columns

[filkod]

Hello everyone!
I need some help with the following issue.

I have the following table:

cap1.JPG

And I need a new table looking like this:

cap2.JPG

Any suggestions?
Thank you!

[Crooza]

Hi and Welcome. It's easier if you give us tables to work with rather than pictures but as it's your first time I put this together. Use this macro - it will put your new data in column E and F

Please Login or Register  to view this content.

[azumi]

Using formula, pls see in the file attach..

see u

[filkod]

Thank both of you guys!! Ecpecially for your speed!!

[filkod]

Dear Crooza,
I don't want the values of zero quantity to appear on the new table.

Thank you!

[filkod]

Dear azumi,
It works great, but the blank cells of the new table have appear the minus sign "-". Is it possible that it doesn't appear?

Thank you!!

[Crooza]

Dear Crooza,
I don't want the values of zero quantity to appear on the new table.

Thank you!

then use this

Please Login or Register  to view this content.

[azumi]

Yes pls see this...

regards

[filkod]

Thank you very much!!!