I would like to create additional row(s) of the same data based on column(Rows#) value.
For example of the Input Data –
Name | Location | Rows# |
Sam | NY | 2 |
David | NJ | 1 |
Joe | HI | 4 |
The out result should be –
Name | Location |
Sam | NY |
Sam | NY |
David | NJ |
Joe | HI |
Joe | HI |
Joe | HI |
Joe | HI |
Is there anyone that can help me get off to the right start with this? Thanks!
Solved! Go to Solution.
This can be done using the Generate Rows tool. Right click over the tool (in Preparation category) and open the sample. The third example in that workflow is very similar to what you are trying to do.
Thank you so much derekbelyea for your support and it is working !!!