Nowadays, it is just a couple of clicks in Power Query. In the old days, this took quite a bit of copy/paste, or perhaps a clever macro. The resulting list needs to have a new row for each combination of size and color, like this: We want to expand the list so that each T-shirt gets a new row for each size option (small, medium, large) and a new row for each color option (blue, black, white, red). Videoīefore we get to the detailed steps, let’s quickly confirm our objective. I’ll demonstrate how we can use Power Query to accomplish this task. We’d like to expand the list of T-shirts and create a new row for each combination of color and size. For example, each T-shirt has the same size and color options. We have a few T-Shirt options that we want repeated for each T-shirt in our list. For example, let’s say we have a list of some sort … we’ll use a list of T-Shirts for this illustration. This post will demonstrate how to insert the same few items into a list and create a new row for each item (or each combination, if multiple items).

Paste list into excel