How to concatenate a list with 3 columns pivot table?

[lirguio]

Hi All,

I actually have a problem, well, better a challenge.. I am trying to do a concatenation of a list similar to the one below, base on a pivot table. e.g.


Supplier Country with spend Supplier Country

HR Capital Kazakhstan

Uzbekistan

Russian Fed.

Uzbekistan

LAB MESK Poland

Poland

LUKA Denmark

Poland

Sweden

Poland

3M Company Argentina

Argentina


Brazil

Brazil


France

France


Germany

Germany


India

India


Italy

Italy


Malaysia

Singapore




The final result I am looking for is to get:







In one column:

Supplier:+Country with spend1 + Country with spendx


HR Capital: Kazakhtan;Russian Fed.



LAB MESK: Poland

LUKA: Denmark;Sweden

3M Company: Argentina;Brazil;France;Germany;India;Italy;Malaysia


In a 2nd column same supplier but using column Supplier Country

My main issue is when the pivot has many blanks lines in the supplier column, how to concatenate all the countries link to the same supplier.


Any ideas on how I can solve the problem.. would be very appreciate.


Many thanks in advance.

Kind regards,


Leonardo

 

[Luke M]

HI Leonardo,

Could you try uploading a sample file? It would help better see what layout you are trying to describe.