Power Query - Data from Specific Cells

Chris 21 Reputation points
2022-05-04T22:41:57.197+00:00

I'm attempting to pull specific data out of an excel template and utilizing the power query feature to consolidate. Unfortunately, I need a cell to duplicate from a row without a header into the file. My goal is to pull from multiple sheets and try to consolidate these packing lists into a useable fileset.

198968-image.png

As you can see attached, I want to pull the data under the PO Header, and then copy it until another cell, preferably the one next to PO Line, and then export. I'm new to power query, and this seems to be hexxing me right now.

Any help is appreciated.

Thanks,
Chris

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,666 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2022-05-04T22:52:30.54+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

    --please don't forget to Accept as answer if the reply is helpful--


0 additional answers

Sort by: Most helpful