Dear Harpreet Singh:- You should Try to Merge and Cell for this select cell A2:A10 then Click Right through mouse go to Format Cells then Alignment then tick Merge cells
With Regards Sandeep Kumar Sharma *“Always laugh when you can. It is cheap medicine.*” On Sat, Feb 21, 2015 at 1:35 PM, Harpreet Singh <rantech...@rediffmail.com> wrote: > First of all let me tell you all that i am totally new to Excel. I never > used it before.. I am in a little trouble, so i need help of your guyz... > Hope you guyz will help me. > > My Problem is : > > > <https://lh4.googleusercontent.com/-Iv7cJSGCf1k/VOg8KaNqLdI/AAAAAAAAAFU/B5MVvwBvEgQ/s1600/Untitled2.png> > > I have two columns "Sr.No" and "Previous Posting" as showing in the image > 1 (Current Situation). Sr.No columns contains numbers in series and > "Previous posting" contains all the posting details in the same column but > in different rows.. > > Now i want to save all these posting details in a new sheet but not in a > single column. Every posting detail should be in a new row with same Serial > Number which belongs to that column, rather than all the posting record in > a single column. > > Results should be like as showing in image 2: > > I hope you will understand my question and suggest me how to do this as i > am totally new. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
