Extracting summary to raw data

Hi,

I have a set of data which lists numerous dog breeds and the number of dogs with and without a disease.

These values are all totalled and I don't have access to the raw data.

However, I want to try and reproduce the raw data for some work I'm doing. So I want to generate a list of every single dog represented in the summary data showing their breed and disease status.

This will take forever manually. Is there anyway to do this with VBA? I have attached an example of what I mean, including a manually produced example of the data I want to try and generate.

Any help would be hugely appreciated.

Sorry, I forgot to attach the file.

Bump! Please help if you can, I don't know where to begin!

To be perfectly honest, that'd be a difficult macro (for me anyway) to write. From the way it looks, it seems possible for your raw report to require more rows than Excel even has.

No it will take 47348 rows...

Mike

Jindon, that's a neat method, will study it closely!

Nucleotide_boy, do you need any help getting these macros installed and running?

Regards
MIke

Originally Posted by jindon

try

Please Login or Register  to view this content.

That is absolutely perfect. Thank you so much!