Power Query Add Columns instead of Rows

[muhleebbin]

Hi,

I am new to power Query but the one time i've used it, it turned out to be amazingly powerful.

The traditional method allows for the columns to be set and to add rows based on the criteria but i'm trying to use it in an accounting setting where instead of the columns being set, it is the rows that are set. Is it possible where as the months go by and we close our books where I can export the data and the power query picks up the new months and adds the columns so that one set of books is captured in one workbook?

Basically if column B was 1/1/20, C 2/1/20 and so forth, this power query would capture 8/1/21 in column U and 9/1/21 in column V as the months values gets added.

Hope this makes sense.

 

[alansidman]

If your original data is in a table (which it should be) and you add a column to the source data it should become part of the table. Then when you refresh your query, it will automatically add the additional column. To be sure this works for you, you may want to test it with some sample data.