How to duplicate data in a table

[Data4Beer]

This is usually the opposite of what people normally want to do, but is there a way to duplicate data by a certain amount in a table?

[Greg_Deckler · Accepted solution]

let
    Source = Table.Combine({Colors, Colors, Colors, Colors})
in
    Source

[Greg_Deckler]

Can you provide an example of what you are asking for?

[Data4Beer]

I would like to duplicate the following data by 4.

Which would give me this result:

[Greg_Deckler · Accepted solution]

let
    Source = Table.Combine({Colors, Colors, Colors, Colors})
in
    Source

[Rfranca · Accepted solution]

hi, @Data4Beer

This is usually the opposite of what people normally want, but is there a way to duplicate by a certain amount in a table?

This is really different, but EDITOR QUERY can do that.

1. Import TABLE1 (which will be duplicated)
2. Edit this query with EDITOR QUERY
3. Combine this TABLE 1 with itself (see figure)
4. I renamed the new table

Please try and test using it. And please mark the right answer as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
 
Best Regards,
Rfranca