Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have following data:
Name, ID
A,1
A,2
A,3
A,4
A,5
B,6
B,7
B,8
B,9
A,98
A,99
B,101
B,121
I want to make it as a range:
O/P:
Name Start End
A 1 5
B 6 9
A 98 99
B 101 121
Any help is highly appreciated
No problem brother