I’ve been working with a lot of microfinance data from the "trends" section of the MIX Market lately and unfortunately the .csv file is not organized in a way that can be easily exported into pivot tables or data visualization software such as Tableau. So, I’ve written this little macro to compile the data into the necessary columns for working with and made it available to you. It should work with most aggregate tables you download from the site. The only thing you need to be sure of is that the source worksheet is titled "Sheet1" and the worksheet for compiling the data is titled "Sheet2". It is a super simple macro, but now I’ve written it so you don’t have to.
Wednesday, April 28, 2010
Excel VB Script For MIX Market
Labels:
Excel,
microfinance,
Mix market,
Tableau,
Tech,
vb
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment