Devam Ediyor

Excel formula to move data in column A to B, C and D

I have an excel spreadsheet with data in column A. every entry is three rows long. there are about 1000 entries in column a that need to be separated into columns B, C and D. So as an example, Entry 1 would be in A1, A2 and A3. lets say it is Name in A1, Address in A2 and Phone number in A3. I want the output to be B1 = Name, C1 = Address and D1 = phone number, then A4,5,6 would be in B2,C2,D2... and so on.

I'd like this done WITHOUT VBA. just want a formula.


I have attached the actual xls for your reference.

Beceriler: Excel

Daha fazlasını gör: formula it, excel vba long, excel spreadsheet formula, excel 2013 vba, excel formula, data in, Column, c1, b2, excel formula spreadsheet spreadsheet, excel 2013 formula, move data excel, excel vba spreadsheet, need formula, excel name phone number, entry data vba excel, entry data vba, data entry vba, phone number address excel, excel formula spreadsheet, data 1000 entries, Data entry spreadsheet excel, data entry formula, xls formula, excel 1000

İşveren Hakkında:
( 50 değerlendirme ) United States

Proje NO: #4461440



Hi, Ready to start your work. Eagerly awaiting for your positive reply. Thanks, Shaik.

%selectedBids___i_period_sub_7% gün içinde 34%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(10 Değerlendirme)

Bu iş için 2 freelancer ortalamada $34 teklif veriyor


Hi my friend, I can do it for you right now!

in %bids___i_period_sub_35% gün içinde34%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)