segrigation of data in 2 cell

[lathish]

[TABLE="width: 264"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Agaram [/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]55712[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]63218[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]64023[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]65680[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]77505[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]87426[/TD]
[/TR]
[TR]
[TD]Agrahara Dasarahalli [/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]33781[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]41899[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]43793[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]47209[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]52903[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]55021[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]77701[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]78606[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]86772[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]88212[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]88880[/TD]
[/TR]
[TR]
[TD]Anjanapura [/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]39902[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]42271[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]44409[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]44411[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]53203[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]60584[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]66704[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]70210[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]71236[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]77731[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]78736[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]78876[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]82186[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]85897[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]86714[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]88605[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]88898[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]90533[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]90856[/TD]
[/TR]
</tbody>[/TABLE]
so i want get answer like
in one column 67654 and next column agaram , Anjanapura

 

[Peter_SSs]

so i want get answer like
in one column 67654 and next column agaram , Anjanapura

In your sample data I cannot see any connection between 67654, agaram and Anjanapura

I think you will need to spell it out more clearly.

 

[lathish]

In your sample data I cannot see any connection between 67654, agaram and Anjanapura

I think you will need to spell it out more clearly.

in agaram 1234
4567
7890
in anjanpura 1234
7654
7868

sir i expect the answer like in one columu 1234 next column agaram and anjanapura

 

[Peter_SSs]

in agaram 1234
4567
7890
in anjanpura 1234
7654
7868

sir i expect the answer like in one columu 1234 next column agaram and anjanapura

OK, in that sample I can see the link but in the first post 67654 was nowhere to be seen.

Now, to further clarify, could there be multiple values that occur in more than one list and if, so, do you want them all listed or are we being given a specific number like 1234 and asked which groups it is in?

For example, can you give and explain the expected results for this data if it is relevant data.

BTW, if you could provide data samples like this where we can clearly see what rows and columns the data is in it would mean that people could help you much easier. My signature block below has help on that.

Excel 2016
	A	B
1	Agaram	0
2		56987
3		12345
4		65324
5		98765
6	Agrahara Dasarahalli	0
7		65324
8		88888
9	Anjanapura	0
10		12345
11		78878
12		65324
13		74215
14		88888
Sheet1