Data Consolidated

[silverar]

Hi guy's
I would like to consolidate data or whatever option is there .
Transform this :

View attachment 686421

TO THIS

View attachment 686422



I tried using consolidate data but the results are bad. COUNTRY Column will be missing.

View attachment 686423



THANKS !

 

[RoryA]

Welcome to the forum.

It looks like you just need a pivot table to me. Simply add the CODE and COUNTRY fields to the row area and the Value to the Values area.

 

[Fluff]

Cross posted Data consolidate

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[silverar]

I did not find the edit button to mention the other forum!

Data consolidate

Hi guy's I would like to consolidate data or whatever option is there . Transform this : 686421 TO THIS 686422

www.excelforum.com