Forum Discussion
Extracting specific cells from multiple sheets to table
Hey, I have a sheet, which is structured for humans and not automation and that has resulted in me having some headaches getting power query to reformat it correctly. From each sheet I'd love to ha...
Hi,
Yes of course - Thank you very much.
I couldn't get Power Query to do anything but delete specific columns, but I must be missing something basic about how to use it.
Example of my if statements:
If H11 = "x"
Put N/A in the rest of the fields
If 0<H10<3000
ThisRegion
ElseIf 3000<H10<4000
This other region
Hope it makes sense.
I may have misunderstood what you are trying to accomplish. You are trying to use Power Query to populate this spreadsheet? Why not just use a formula to populate those cells?
Pat
