Comparing 2 Columns and Repeating UserID and Questions


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)

Hi @Brandon_Rinear
As of my understanding do you wnat to repeat all the questions to all the user id right ??

Yes, but I need the result to be also like this:

UserID Questions
1 Question #1
1 Question #2
1 Question #3
2 Question #1
2 Question #2
2 Question #3
… and so on until no more Users

Hi @Brandon_Rinear

Please find the attached xaml file , I developed a project as per your requirement

Hope its solves your issue
test20.xaml (8.8 KB)

Update me whether your issue resolved or not

Robin S


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.

Nevermind. I updated my UiPath to fit your version.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.