Hi Excel Forum,
1.In the attached Excel file, Table 1 mimics my original large data set
2.The original dataset is having 25 data points under variable Quarter; and 15 villages under each Quarter
Background:
I wanted to make a separate chart for each village, showing how pre and post income is trending with Quarters
I have just created a chart for first 2 villages, namely AA_1 and AA_2 (pl see Chart 1 and 2 in the attached)
To create this chart, I should pre-process data like in Table 2 and Table 3.
Question:
Could anyone help me to create the pre-processed two tables using v-lookup approach. You would see I have created table2 and 3 using a very clumsy manual cell linking approach.
Thank you
Mirisage
Bookmarks