I have a problem that I have been trying to figure out and I am wondering if anyone has any suggestions. I need 2 columns UserID and Questions in a new sheet. I have a list of User IDs that I need to repeat the number of times a different question appears. For Instance, if I had 100 Users with 10 Questions, I need 1 UserID to repeat 10 times. Then, the 10 questions will copy down for the next UserID to be repeated 10 times.
I made an example excel file below to work on below.
Sheet1 is input, I need the output in a separate sheet.
What is in the last activity? The file I downloaded has everything but the last activity. It says the activity is missing or invalid activity. The read range and assign is there not the 3rd.