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:-)
