Forum Discussion
Organizing groups data with inconsistent row count
Hello, I am not sure exactly how to put this into words so I was unable to search a solution. I have a large list of items grouped into sections in a word document. I am trying to organize them i...
mattcyborg Easiest done with Get&Transform Data (a.k.a. Power Query). The attached file contains an example on the basis of the data you provided. In summary, the steps are as follows:
1) Connect to your list
2) Extract the chapter number into its own column
3) Get rid of the unnecessary rows
4) Sort the list as desired
5) Load back to Excel.
Let me know if you are comfortable with this.
Riny_van_Eekelen aaahhh I think I got it. I had the chapters extracted but was stuck there with large blank row gaps between. I saw you used fill down and that got me to where I needed to be. Thanks that helped speed up this process significantly!
mattcyborg Great!
