12 monthly blank columns in PQ and when actual data is loaded it should populate the relevant blank columns|Power Query|Excel Forum|My Online Training Hub

Dear All,

I have created 12 blank columns ((M1 - M12) these are the names of the columns) through power query and loaded it to a table.

I'll be getting the actual monthly data from a folder via PQ. The monthly sheet names are M1, M2 and so on.

When I get the actual monthly data for M1 or any month, I will put it into the folder, What I want is that PQ should check the sheet name and then populate the relevant month's blank column with the actual data for that month.

For example:

The M1 blank column should be populated when I get the actual monthly data for M1.

If I put M5 actual data file in the folder, PQ should check and automatically populate the M5 blank row with the actual M5 data.

Your help would be really appreciated.