Data consolidate

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

TO THIS
cons2.PNG



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

THANKS !

Shared with mrexcelDotcom
Link to the same threat in another forum!
mrexcel.com/board/threads/data-consolidated.1139849/[/url]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

I share your concern AliGW, I would like to let the people to understand what is the point of this post!

I am asking you to attach a sample workbook. Do you have a problem with this?

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)