Forum Discussion
How to duplicate data in a table
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?
let Source = Table.Combine({Colors, Colors, Colors, Colors}) in Sourcehi, 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
4 Replies
Can you provide an example of what you are asking for?
I would like to duplicate the following data by 4.
Which would give me this result:
let Source = Table.Combine({Colors, Colors, Colors, Colors}) in Source
