Hi All,
As I was working on one sheet, which contains data in group of 2,separated by one single blank row, my task is to find out all similar groups from the first column and put it together.
For example the first pair data I have in first row as "jyoti" and in 2nd row I have "kumari" now in the same sheet and in the first column somewhere I will be having "kumari" and "singh" in a pair and "jyoti" "neer" in another pair.
Now all I need is to group this 3 pair together which will give me a result of a group jyoti, Kumari, Singh, neer all in different line but together.
As, till now I am doing it manually, so any idea Wil be a great help
Bookmarks