最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

powerquery - automatically creating a table in excel with power query - Stack Overflow

programmeradmin2浏览0评论

i try to create an excel list with employees. I have a list with all the employee's names and their e-mail.

Now I want to create a new table with the year, month, the e-mail, their name and a column, filled with an x.

Like this:

Year | Month | E-Mail | Name | Column

2024 -> Jan -> @mail1 -> name1 -> x

2024 -> Jan -> @mail2 -> name2 -> x

2024 -> Feb -> @mail1 -> name1 -> x

2024 -> Feb -> @mail2 -> name2 -> x

2024 -> Mar -> @mail1 -> ...

2024 -> ...

...

2025 -> Jan -> @mail1 -> name1 -> x

2025 -> Jan -> @mail2 -> name2 -> x

2025 -> Feb -> @mail1 -> name1 -> x

2025 -> Feb -> @mail2 -> name2 -> x

...

The goal is that if I change one employee's name, email or even delete the line in the first table, that it automatically takes over for the current month.

Could someone help me please to write a M-Code for this?

Thanks in advance!

发布评论

评论列表(0)

  1. 暂无评论