How to apply transformations over multiple worksheets? RRS feed

  • Question

  • I thought this would be a very easy and well documented solution but surprisingly the only thing that comes up when I google it is how to merge multiple sheets together.

    What I would like to do is a step before that - I've constructed a series of transformations on one work sheet, and now wish it to be repeated for the other worksheets in the workbook. I have loaded all the worksheets into Power Query.

    What is the recommended way for repeating my transformations?

    Tuesday, November 24, 2015 4:19 PM


All replies

  • Hi PuzzledGeek2. You'll want to search for information on PQ functions. This post, for example, shows how to turn a regular query into one that accepts parameters and can be applied to different sources of data.


    Tuesday, November 24, 2015 6:31 PM
  • Ok great thanks - even that little nugget of information helps enormously as now I know that it can't be done unless you delve into M. Saves me a lot of effort googling thinking that I'm missing something obvious.

    Tuesday, November 24, 2015 8:38 PM