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 :

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.

Attached Files

1234.xlsx (29.2 KB, 9 views)

Hi and welcome
could you please post your sheet instead of a picture?
Click on " go advanced" then "manage attachments" button

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is my Excel Sheet..

Attached Files

1234.xlsx (29.2 KB, 15 views)

Unmerge the cells in the columns A-K. Simply copy the first row of data for each serial# down until you get to the next serial number. Repeat for each. If this is all the data you need to work with, it's just a matter of some elbow grease.

Is this supplied by Microsoft?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post