How to arrange vertical Vcards column into horizontal rows ?

[m.rizeg]

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]

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]

also see List Addressess in rows.xls

[m.rizeg]

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]

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]

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]

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

[solario]

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

Pleased to meet you all! First time here and totally green, I have exactly the same problem , but there is not enough information in your reply here for me. I need baby steps, please.

My phone bill is online & in 6 columns. I copied it and pasted across to excel (2000), it appeared as one column. The best I can manage at my level is to paste special/transpose 6 cells at a time which gets the result of the data into 6 columns, but far too slow.

My single column of data starts from cell #A2, what's next? Do I highlight the column, then ctrl+C? where and at what step do I enter the formula? and what comes next after that?

[arlu1201]

solario,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

[solario]

Thanks for that. Will do!!