Hi all ,
i am on a excel sheet where in i have 2 names "LIP" and "GIP" in column A. data is like
GIP
GIP
LIP
LIP
LIP
LIP
GIP
LIP
GIP
GIP
GIP
GIP
GIP
LIP
LIP
I need the rows should be arranged in alternate manner. like
GIP
LIP
GIP
LIP
GIP
LIP and so on........
Any macro or formula to do...