Redistribute a Delimited Column Of Data into Separate Rows (Keeping Other Data As Is)

[Rick Rothstein]

When I run the code, it fullfills the other rest of the column with the value of last unempty cell. It stretches the last cell to the length of the longest column. Does any body have an idea with this code to fix it?

That is how the code was designed. When data is missing and the user wants to fill it in, normally they want to do that fill for the data item and, since there is no way to know how far that last item should be filled for, I chose to use the row with the last data item as the stopping point. Until your post, that is the functionality everyone has wanted. If you post a sample worksheet with existing data on Sheet1 and what you want that data to look like on Sheet2, I will try to modify the code for you to do what you show me you want.

[aselcuks]

That is how the code was designed. When data is missing and the user wants to fill it in, normally they want to do that fill for the data item and, since there is no way to know how far that last item should be filled for, I chose to use the row with the last data item as the stopping point. Until your post, that is the functionality everyone has wanted. If you post a sample worksheet with existing data on Sheet1 and what you want that data to look like on Sheet2, I will try to modify the code for you to do what you show me you want.

MMVAL V1_BOM.xls

That is the sheet I wanna modify and after the code executed I want it to be like;



MMVAL V1_BOM_modified.xls


but It fullfills the rest of column K with the last statement "C15" and it goes down to length of longest column.


Thank you for your concern.

Regards

[aselcuks]

MMVAL V1_BOM.xls

That is the sheet I wanna modify and after the code executed I want it to be like;



MMVAL V1_BOM_modified.xls


but It fullfills the rest of column K with the last statement "C15" and it goes down to length of longest column.


Thank you for your concern.

Regards

Also if there is any blank cell lets say G20, after execution it fulfills the shifted cell of G20 with the value of G19, it doesnt leave it blank as it was before.