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.
Book3.xlsx (8.8 KB)