aravindhan_3
03-03-2016, 04:01 AM
Hi,
I have countries in column A and items sold in col B, I want to transport the same into columns, for example the country India should be in row 1, and below all those items should be there, China in row 2 & the items below that.
I have attached the sample file for reference,
please help me with the macro for this, I have got about 100000 rows & 65 countries.
Regards
Arvind
I have countries in column A and items sold in col B, I want to transport the same into columns, for example the country India should be in row 1, and below all those items should be there, China in row 2 & the items below that.
I have attached the sample file for reference,
please help me with the macro for this, I have got about 100000 rows & 65 countries.
Regards
Arvind