Loop through column

[MP1]

Hi, 

I want to write logic for looping through columns in table for the particular row.

Can we use numbers to recognise the columns or is there any other way to iterate through columns?

Thanks In Advance.

[MP1]

In Table 1 , Richard has 1 as value for A1 and A4.  and because of that it's reflecting twice in tab2 table. My requirement is in tab 2, I only need one row for each user ( any random out of two ) . 

Table 1:

Name	A1	A2	A3	A4
Sam	1
Linda			1
Richard	1			1
Sandy		1
Ben				1
Tom				1

lookup table :- 

Code	Area
A1	ABC
A2	XYZ
A3	ABC
A4	EFG

Tab 2:

Name	Code	Value
Sam	ABC	1
Linda	ABC	1
Richard	ABC	1
Richard	EFG	1
Sandy	XYZ	1
Ben	EFG	1
Tom	EFG	1