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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Q1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]0[/TD]
[TD]No change[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]Increase[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]Decrease[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Q2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0[/TD]
[TD]High[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1[/TD]
[TD]Same[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[TD]Low[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]