How to arrange vertical Vcards column into horizontal rows ?

**m.rizeg** · 11-22-2011, 01:21 AM

Hi,

First time to see you all and happy..

I have a simple problem..

I need to arrange vertical Vcards column into horizontal rows..

Sample:

I have this data:

Adroit Building Material Trading Enterprises L.L.C
Phone : +9714 3332031
Fax : +9714 3332286
P.O.Box : 12216
E-mail :adroit @ emirates. net. ae

Al Futtaim Tarmac Pvt. Ltd.
Phone : +9714 3331670
Fax : +9714 3330624
P.O.Box : 87111
E-mail : Info @ aftarmac. com

I want to arrange them into this output:

Row 1: Adroit Building Material Trading Enterprises L.L.C Phone : +9714 3332031 Fax : +9714 3332286 P.O.Box : 12216 E-mail : adroit @ emirates. net. ae

Row 2: Al Futtaim Tarmac Pvt. Ltd. Phone : +9714 3331670 Fax : +9714 3330624 P.O.Box : 87111 E-mail : Info @ aftarmac. com

That's it..

Thanks

**Azam Ali** · 11-22-2011, 01:40 AM

suppose your data is started from cell # A2, try

=IF(AND(LEN(A1)=0,LEN(A2)>0),A2&" "&A3&" "&A4&" "&A5&" "&A6,"") and copy down

then paste special values and sort

**Azam Ali** · 11-22-2011, 01:53 AM

also see List Addressess in rows.xls

**m.rizeg** · 11-26-2011, 01:09 PM

Thanks Brother..

The Second post had a great result,
And the most wanted result is like what I attached here.
I want every single row to be in a certain column.

Thanks again.

**JieJenn** · 11-26-2011, 01:21 PM

This can be done easily via macro as I am assuming the Current Data column data is imported from an external resource, so you basically want to appendix the list. Otherwise Azam's formula works perfectly.

**m.rizeg** · 11-26-2011, 08:45 PM

Yes yes that's exactly what i want..

Now, How could I use the formula in a practical way ?

I have such a big data as a list, i need to convert them all into certain columns !

Thanks for help.

**m.rizeg** · 11-27-2011, 12:47 AM

Thanksfull for the fantastic Forum..

It still has the last step of the solution, I need to get the practical way to arrange the list of my data to be in a table mode, please.

Thanks