Re: How to arrange vertical Vcards column into horizontal rows ?
Quote Originally Posted by Azam Ali View Post 2648297
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, so 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, like a vertical vcard list. 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.
I found exactly what I want here (2648297), but while the guy with the vcard list problem was delighted with the solution he was given, the answer made too many assumptions about my own prior knowledge, so I am still swimming around out here.
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?
Bookmarks