EmranHashmi said:
Assalam Alaikm dosto umeed karta hun sab kheriat se honge.
MS Excel me ek problem arahi hai
mere pas kuch data hai jo ek hi column me 1042361 cells me hai . me us ko ek Cell me karna chahta hun. jis k lye maine FORMULA =TRANSPOSE(CONCATENATE(A1:A500)) bhi apply kya but ye 500 cells tak hi karta hai. 1042361 cells ko karne me mjhe sara din lag jaega . plz koi tareeka bataen kam se kam 5000 i mean =TRANSPOSE(CONCATENATE(A1:A5000)) tak kaam kare. jab 5000 ka forumula lgata hun to Formula too long ka error ajata hai. Umeed hai me apna masla ap experts ko samjha paya hoga. Iam waiting for experts reply.
Agar m ghalti naee kr raha tu aap formula ulta laga rahe hain may be typo.
Code:
=concatenate(transpose(range))
Excel k cells ki apni limit hote ha. jis ki waja sa ya masle aate hain. excel k cel m(2010,2013,2016 excel) m aik cell m aap 10000 charachter lekh sakte hain. aur normally ya 256 charachter ki hote ha. Is waja sa na he aap itne lambi range p concatenate ya transpose ka function naee use kr skate. Aap formula choti range p lagain tu thk rahe ga. Excel 4000 rows tk formula ko calculate kar le ga. lekan jab result cell m show krna ho ga tu ya phir error de ga aap ko q k cell m itne character naee atte.
agar aap bata sakain k aap krna kya chah rahe hain jis m itne zayda cell involve hain tu shayd koi dosra method ho jis ki waja sa aap ka masla hal ho jay. other wise aisa mumkin naee.
N.B: ya masla concatenate aur transpose function ko use krne m aata ha. sum, divide etc p kitne bhe lambi range ho koi masla naee ho ga.
regards,
Bookmarks