Creating additional rows from each read row in table

[shakirdudhia]

Hi everyone,

Very novice power bi user, but understand very simple basics.

In short, I want to use a loop read through a table and generate additional information based on that.

As an example: For each row that is read, 3 rows (for example, can be more but to still be determined) are created with specific information brought in from other tables (the information of these is irrelevant). This is being done because this information will be used by another program which needs the input as such.

Once all the rows have been read from the initial table and the additional rows have been created, they can all be placed into a separate table.

Is it possible to do this in power query?

So as an exmaple:

Initial input is as follows

Output would look something like this:

The information pertaining to the other columns can be assumed to be arbitrary and be anything from text to numbers. I am solely focussed on knowing how to create this new table with the number of rows I need per initial table rows.

Thanking you in advance.

[dufoq3]

Hi @shakirdudhia, it is possible, but provide sample data in usable format (read link below if you don't know how). Provide also expected result based on sample data. We need also such table with [Location], [House] and [Sport]