Forum Discussion
Automatically move Excel rows up or down for certain columns so that all data of rows align well
River_998 This is really something for Power Query (PQ). I downloaded the three nutrition reports you showed in the screenshot. Saved them in one folder and connected PQ to that folder. Did some basic cleaning up and created a pivot table that automatically lines up all nutrients for you. The end result (just a portion of it) looks like this:
It that what had in mind?
River_998 This is really something for Power Query (PQ). I downloaded the three nutrition reports you showed in the screenshot. Saved them in one folder and connected PQ to that folder. Did some basic cleaning up and created a pivot table that automatically lines up all nutrients for you. The end result (just a portion of it) looks like this:
It that what had in mind?
Riny_van_Eekelen - Thank you. I think that your method would be helpful. What specific steps did you do in this method?
River_998 It requires Power Query. Not difficult but it might take an effort to learn it if you have never used it.