[COLOR=var(--primary-text)]Hi
how I can reshape the data
I want to put the values of NTL when DHSCLUS is 1 under DHSCLUS_1 and when DHSCLUS is 2 value of NTL under DHSCLUS_2. and so on
I have tried using the formula but Excel is taking a lot of time.
how i can do it with VBA, please
[/COLOR]
how I can reshape the data
I want to put the values of NTL when DHSCLUS is 1 under DHSCLUS_1 and when DHSCLUS is 2 value of NTL under DHSCLUS_2. and so on
I have tried using the formula but Excel is taking a lot of time.
how i can do it with VBA, please
[/COLOR]