Two columns data in single column conditionally

[nur2544]

Dear all, I am having data in two columns (A & B ). Now I want to get the data in the single column(column C) . Here column A(Name) & Column B(Mobile No). it is something like below.
Here is my input data

Please Login or Register  to view this content.

i want to get output results like below in the column C

Please Login or Register  to view this content.

[MickG]

Try :-

Please Login or Register  to view this content.

Regards Mick

[nur2544]

Hi Mick, You did excellent job for me. It works perfectly, thanks for your nice job .

[Richard Buttrey]

Hi,

One non macro way (or indeed with a macro if you get the macro to perform these steps)

1. Copy column B immediately under column A
2. In C1 enter the formula

Please Login or Register  to view this content.

and copy down
3. In C7 enter the formula

Please Login or Register  to view this content.

and copy down to C12
4. Sort A:C using column C as the key

[nur2544]

Hi Richard , thanks for formula solution..

[TMS]

Just out of interest, another VBA option:

Please Login or Register  to view this content.

Regards, TMS

[nur2544]

Hi TMS, Excellent job , Thanks for your support.

[TMS]

You're welcome. Thanks for the rep.