paste list into excel each word a column

From within Power Query select the Add Column > Custom Column command. In this example, we’ll use Custom Columns. There are several ways to create the Size and Color columns. So at this point, we just need to get the delimited lists into each row. The end game is that we will ultimately split the delimited lists into new rows. Each column will contain a delimited list of values for example, small, medium, large. Here, we have two options (size and color), so we’ll create two columns. Our goal in this step is to create one column for each option list. Time to create the size and color columns. This will load our T-Shirt table into Power Query, and we should see something like this in the Power Query Editor:ĭone. To load our list into Power Query, we select any cell in the table and use the Data > From Table/Range command. We’ll accomplish our objective with these steps:įirst up, getting the T-Shirt list into Power Query. 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 each word a column