Generate new table based on existing tables?

[kestefon]

I have a table of national data that needs to be "localized". In other words, I have percentages for each US state (this is just proprietary data I have that's specific to my business), and essentially I'm distributing each data point across the entire US based on those percentages.

So, I would start in Row A, and create 50 new rows by multiplying the data point in Row A by my factor for all 50 states. Then I would move to Row B, and multiply that data point by each state's factor. Then Row C, and so on and so on. Hopefully that makes sense.

I could do this in Excel with a smaller dataset and VLOOKUP, but since the output will be in the 1-2 million row range, I want to do this in PowerPivot. Is this possible? Any ideas?

Thanks