Enrich dataset with new information

Hello,

I am struggling with a larger List of Products and I am supposed to make it even more detailed.

Currently I have the Sales for Product A, Product B and so on. Now I need a List where I attribute a Region to each of the Product names. Product A Asia, Product A Nord America...

One Line in the current list needs to become 4 new, I attached an example table that should make it clearer. Sorry for the

Thank you very much!

p.s. Is there an opportunity to donate to the forum (besides buying points?).

Hell Carim,

thank you so much! Unfortunately I can not execute the makro, it seems our administrators blocked the option to execute it for downloaded files.

Could you post the code here?

Seems that I need to learn VBA, until know I always found a way around it :D

You can also try:

Please Login or Register  to view this content.

Thank you very much to both of you!

I will try to figure the rest out on my own, I never touched makro / VBA before so I will start with that tonight.

Have a great evening / day.

Hello Carim,

thank you very much for the solution with formulas, much appreciated!

I also found another solution, less elegant due to my limited skills but kinda works as well. I added a helper colum with numbers 1,5,9... and below the content I added the left out numbers with otherwise empty rows. That way I created empty rows within my table as soon as I sorted smallest to largest. I added a formula that copied the Product name from the cell above and just flash filled the region colum.


Attachment 712423