vpraveen3843 Posted June 6, 2013 Report Share Posted June 6, 2013 How to merge 15,000 row values into single cell. Evarikanna thelusa ela cheyalo. Its very urgent! Quote Link to comment Share on other sites More sharing options...
pinky123 Posted June 6, 2013 Report Share Posted June 6, 2013 aa cells anni okkate column lo unnaya? Quote Link to comment Share on other sites More sharing options...
vpraveen3843 Posted June 6, 2013 Author Report Share Posted June 6, 2013 yes anni okate column lo unnayi. motham 15,000 rows in one column.. Quote Link to comment Share on other sites More sharing options...
pinky123 Posted June 6, 2013 Report Share Posted June 6, 2013 lets say nee data anta column A lo undi starting from A1.. B2 lo "=A1&" "&A2" B3 lo "=B2&" "&A3" * dont type double-quotes taruvata B3 cell ni copy chesi.. B4 to B1500 motham highlight chesi paste cheyyi.. the above formula will place a "space" between the contents of each cell. Quote Link to comment Share on other sites More sharing options...
vpraveen3843 Posted June 6, 2013 Author Report Share Posted June 6, 2013 All 15000 row values oka cell loki ravali.., ila ayithe vasthaya? Quote Link to comment Share on other sites More sharing options...
pinky123 Posted June 6, 2013 Report Share Posted June 6, 2013 motham data only column A lo unte ee method tho vastundi Quote Link to comment Share on other sites More sharing options...
Tatichettu_Tingarodu Posted June 6, 2013 Report Share Posted June 6, 2013 =concatenate() function vaduuuuuuuuuuuuuu Quote Link to comment Share on other sites More sharing options...
vpraveen3843 Posted June 6, 2013 Author Report Share Posted June 6, 2013 yes it worked brother, thanks.. Quote Link to comment Share on other sites More sharing options...
nrikittu Posted June 6, 2013 Report Share Posted June 6, 2013 ok Quote Link to comment Share on other sites More sharing options...
Chicha1 Posted June 7, 2013 Report Share Posted June 7, 2013 [img]http://www.andhrafriends.com/uploads/profile/photo-thumb-30724.jpg?_r=1343339226[/img] Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.