Merge different cell & O/P in first cell

[EC_08]

Hi,

I have 15000 raw data as per below , Column A contain different id there home address split in column b (A,B,C,D) i want output in first cell of C column (ABCD) agints each id.

Column A	Column B	Column C
Id	Address	O/P
OT001	A	ABCD
	B
	C
	D
PTT001	F	FG
	G

<colgroup><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col width="64" span="3" style="width:48pt"></colgroup><tbody>
</tbody>

 

[Rick Rothstein]

its working .. but if possible formula base soluation. pls.

You said this in Message #5...

"But my problem is I don't know my address in column B split in how many cell .
In your formula is my address split in 5 to 7 or may be in 10 cell then what to do...."

Based on that, I started my response in Message #6 with this which I still think applies...

"With the variability your are describing, I do not see how a formula solution is possible,..."

 

[Peter_SSs]

its working .. but if possible formula base soluation. pls.

Hard to keep up with your changes of mind - in post #3 you said a macro was ok

A formula solution is possible. You can keep extending my previous formula pretty much as long as you like, but you have to decide what the maximum number of items there might be to decide how much to extend the formula.

Keep adding the bold, underlined section just inside the final ")" and each time increment the red numbers by one

=IF(A2="","",B2&IF(COUNTA(A2:A3)=1,B3,"")&IF(COUNTA(A2:A4)=1,B4,"")&IF(COUNTA(A2:A5)=1,B5,""))