![]() ![]() Note: The steps below are presented with Excel for Windows 2016. ![]() We’ll use Power Query to help us out as follows: Let’s say our export contains a delimited list of values, as shown below.īut, we need to split the delimited list and put them into rows, like this:Įach OrderID may have a variable number of rows, for example, some orders have 4 rows and some 3. ![]() Well, what are we waiting for … let’s get to it! Objective In this post, we’ll do the opposite and convert a delimited list into rows. In the first post, we combined rows into a delimited list. This is the second of two related posts that demonstrate how to use Power Query to deal with rows and delimited lists. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |