Forum Discussion
Solved
Combine two lists into one to create a course enrolment csv
Hi I regularly need to create a simple csv list to enrol users onto courses on our VLE. The csv needs to have: CourseCode,UserName I have CourseCode and UserName in separate tables. See example fi...
Easiest way id with Power Query, but since you are on Mac that doesn't work. Half-manual way
- create another table with only one empty row in it
add two formulas in columns of this row
=INDEX(Table1[CourseCode], INT( (ROW()-ROW(Table5[[#Headers],[CourceCode]])-1)/ROWS(Table2))+1)and
=INDEX(Table2[UserName], MOD( ROW()-ROW(Table5[[#Headers],[UserName]])-1, ROWS(Table2))+1)Number to the right calculates which will be last row. In our case enter H5:I88 into name box, this range will be select.
Ctrl+D. Table will be expanded and filled.
trvincent See attached, in column H, for the simplest solution.
- Great! Thanks very much for your helpful and swift response. A little embarrassing I didn't think of that!
