I have a long list of people names in an excel column. I'd like to add rows for each day of the week to each value. Example below. Thank you!
Current:
Bill |
Frank |
Steve |
Mike |
Hank |
What I want:
Bill | Monday |
Tuesday | |
Wednesday | |
Thursday | |
Friday | |
Frank | Monday |
Tuesday | |
Wednesday |
Solved! Go to Solution.
If you add a Text Input tool that contains the days of the week you wish to add to each name, then add an Append tool (with the Target input as your list of names and the Source input as your list of weekdays) that should give you the results you are looking for!
NJ
Thank you NJ!! Much appreciated.