Power Query - Data from Specific Cells

Question

question

Chris-9116 asked May 4, '22 DSPatrick commented May 5, '22

Power Query - Data from Specific Cells

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.

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

power-query-not-supported

image.png (29.4 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-05-04T22:52:30.54Z

DSPatrick answered May 4, '22 DSPatrick commented May 5, '22

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--

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Chris-9116 · May 05 at 12:20 AM

Thanks!

0 ·

DSPatrick Chris-9116 · May 05 at 12:21 AM

You're welcome.

0 ·

question