Hi,
I would like to transpose a single column into multiple rows based on 2 criteria:
1. If "name" change the letter, it will create new row
2. If each "name" have more than 5 "node", it will create new row
Input:
Output:
Any help/advice will be very appreciated. Thanks
I would like to transpose a single column into multiple rows based on 2 criteria:
1. If "name" change the letter, it will create new row
2. If each "name" have more than 5 "node", it will create new row
Input:
Output:
Any help/advice will be very appreciated. Thanks