Pulling only certain text criteria into another cell

[KayCee]

Hello,

I'm trying to create a spreadsheet that can automatically generate meeting dates in a year. I have the current spreadsheet below where I have a dropdown option for column D and a formula in Column E of =LET(s,SWITCH(D2,"Annual",12,"Semi-Annual",6,"Tri-Annual",4),IF(D2="","",TEXTJOIN(", ",,TEXT(EDATE(B2,SEQUENCE(12/s,,s,s)),"mmmm 'y")))). For Column A, I need to be able to pull the months generated in column E and create duplicates for a household if there is more than one month listed in E. This would allow me to sort the spreadsheet my months so we can see who we need to meet with in a given month. Is it possible to do this?

 

[KayCee]

Whatever comes after the in is just the name of the last step used in the query. The unicode character (the arrow) shouldn't cause issues as I've used them as column headers in the past too, but try removing it to see if that fixes things.

Now I'm getting this error.

 

[KayCee]

Whatever comes after the in is just the name of the last step used in the query. The unicode character (the arrow) shouldn't cause issues as I've used them as column headers in the past too, but try removing it to see if that fixes things.

Now I'm getting the error code below. I've tried everything I can think of to fix it.

 

[severynm]

Sorry. Thanks for the extra ping. That step is in the wrong format. The column names are nested in braces, meaning the Table.DuplicateColumn step only has two parameters: a name, and a second one which it cannot recognize. It should look something like

= Table.DuplicateColumn(#"Changed Type All Cols", "Meeting Months", "Meeting Months - temp")

Did you try to delete and recreate the step using the GUI buttons? Sometimes it is easier just to redo the step with the ribbon buttons or mouse right click (and then have PQ automatically create the M code) then to try to figure out all of the syntax error minutia. The braces only come into play when you are renaming multiple columns in one step, but again, it's much easier to just double click the column headers to rename them yourself and have the system create the code for you.