# join Several Columns of data into one and return the name of the rows

1. ## join Several Columns of data into one and return the name of the rows

Hey
I need help to find a good way, maybe in several steps to join several columns of data into one and return the name of the rows that are most to the left or right - depending on the data.

I have this data spread out over several columns and several of the columns have the same numbers.
I want to join them into only one column and return the row header for each.
When there are the same number in several of the rows the one furthest to the left or right will be the one that give me the row header.

example of the data and the right answer.

2. ## Re: join Several Columns of data into one and return the name of the rows

=LOOKUP(9^9,A2:K2,\$A\$1:\$K\$1)

3. ## Re: join Several Columns of data into one and return the name of the rows

Thanks Bo_Ry this saved me a lot of time thanks! Great solution!

edit it ditt not work from line 38 to 44 for example.

4. ## Re: join Several Columns of data into one and return the name of the rows

Originally Posted by Bo_Ry

=LOOKUP(9^9,A2:K2,\$A\$1:\$K\$1)
works up to line 38.
for example between 38 and 44 .

It should return D but returns E, should return A but returns E. and so on

D E
A E
B E
B E
D E
D E
C E

I was too fast to check this.

5. ## Re: join Several Columns of data into one and return the name of the rows

=LOOKUP(1,0/FREQUENCY(0,1/(ABS(COLUMN(A2:K2)-6)+1)/(1+(A2:K2<>"")*10^9)),TRANSPOSE(\$A\$1:\$K\$1))

6. ## Re: join Several Columns of data into one and return the name of the rows

Alternative:
M2:

``Please Login or Register  to view this content.``
Drag down

There are currently 1 users browsing this thread. (0 members and 1 guests)