Excel formula or macro for cleaning survey data

[dreema89]

Hi there everyone,

I really need an Excel formula or macro (ideally copy/paste since my VBA is not great) that lets you change the index and lookup array based on the question identifier. So essentially looking at data below, I want my index to change from C2-C4 to C7-C9 based on the identifier in B1 (Q1) and B6 (Q2). I also want my lookup array to change from B2-B4 to B7-B9 across columns on an output sheet.

If anyone could help - that would be really appreciated!!

Thanks,
Reema

A	B	C
1	Q1
2	0	No change
3	1	Increase
4	2	Decrease
5
6	Q2
7	0	High
8	1	Same
9	2	Low
10

<tbody>
</tbody>