Power Query (Duplicating row based on 2 column value)
Dear Expert.
Can you please guide me to achieve this task in power query :-
I'm using power query, and having many tables in excel worksheet about student courses, one of the table name is (Required Courses) illustrates the following fields (Table # 1 - as mentioned below)
- Phase : Student Level (Bachelor or Diploma)
- LVL : Student semester
- Course: Course Code
- Course Name
- Course Type : (General -OR- Specialist)
- Theoretical Classes : this column illustrates number of classes to be created to accommodate the number of student.
- Practical Classes : this column illustrates number of classes to be created to accommodate the number of student.
(Table # 1)
| Phase | LVL | Course | Course type | Theoretical Classes | Practical Classes |
| BA | UG1 | MTM-341 | Specialist | 1 | |
| BA | UG2 | ANJ-302 | General | 1 | 1 |
| BA | UG2 | RYA-302 | General | 1 | 2 |
| BA | UG2 | MTM-322 | Specialist | 2 | 2 |
What I'm looking for is that power query would duplicate each records based on the numbers indicated in [Theoretical Classes] column or [Practical Classes] column, in addition to fill [Class Type] value if its Theoretical or Practical classes (as describe here below in Table # 2)
(Table # 2)
| Phase | LVL | Course | Course type | Class Type | My Comments | |||
| BA | UG1 | MTM-341 | Specialist | Theoretical Classes | As this Course is having nbr (1) in Theoretical Classes column in above Table # 1 | |||
| BA | UG2 | ANJ-302 | General | Theoretical Classes | As this Course is having nbr (1) in Theoretical Classes column and nbr (1) in Practoical Classes , then its been repeat it twice , taking int consideration that Class Type is filled accordingly | |||
| BA | UG2 | ANJ-302 | General | Practical Classes | ||||
| BA | UG2 | RYA-302 | General | Theoretical Classes | This course having nbr (1) in Theoretical Classes column and nbr (2) in Practical Classes , then its been repeated 3 times and Class type is filled accordingly. | |||
| BA | UG2 | RYA-302 | General | Practical Classes | ||||
| BA | UG2 | RYA-302 | General | Practical Classes | ||||
| BA | UG2 | MTM-322 | Specialist | Theoretical Classes | As this class has number (2) In Theoretical Class and nbr (2) Practical class , its been repeated 4 times, in addition Class Type column is updated accordingly. | |||
| BA | UG2 | MTM-322 | Specialist | Theoretical Classes | ||||
| BA | UG2 | MTM-322 | Specialist | Practical Classes | ||||
| BA | UG2 | MTM-322 | Specialist | Practical Classes | ||||
Any guidance and help would be highly appreciate it.
Thank you.
