Hi There!
I need to add a new column to below data set, Please note below data has counting from 1 to 4 then repeating but my data set keep varying, next month i may have 1 to 5 then repeating.
Data |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
1 |
2 |
3 |
4 |
Expected outcome.
Data | Name |
1 | Data set 1 |
2 | Data set 1 |
3 | Data set 1 |
4 | Data set 1 |
1 | Data set 2 |
2 | Data set 2 |
3 | Data set 2 |
4 | Data set 2 |
1 | Data set 3 |
2 | Data set 3 |
3 | Data set 3 |
4 | Data set 3 |
Solved! Go to Solution.
Thanks Mike:-)