Thread: [Solved] Sorting or an Excel formula to insert a blank row after ending a series.
View Single Post
 
Old 09-07-2011, 01:27 AM
PRADEEPB270's Avatar
PRADEEPB270 PRADEEPB270 is offline Windows Vista Office 2007
Novice
  
Join Date: Aug 2011
Location: Gurgaon-INDIA
Posts: 17
PRADEEPB270 is on a distinguished road
Default Sorting or an Excel formula to insert a blank row after ending a series.
I have a file consisting so many part codes in a column.Most of the part codes are same.Now,I want when a particular part code end,a blank row should be insert and a new part code begin and so on.Is it possible through excel?

Pl.refer attach file for more clarification.
Attached Files
File Type: xlsx Book1.xlsx (8.4 KB, 10 views)
Reply With Quote