AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Power query in excel for mac3/8/2024 I can see the "5" in the List.Skip line is the magic. Honestly, I don't know how to write in the M programming language and I never intend to learn. Someone on a forum somewhere will know the M code to solve your problem. He sent me some M code that I could type in the Advanced Editor found on the View tab in Power Query.įigure 1043. I reached out to Miguel Escobar of PowerQuery.Training. This was causing the Power Query interface to fail, assuming there were only two columns in the data instead of 10 columns. The actual headings for the data started in row 5. For example, I had a person in a seminar where their CSV files started with 4 rows of identifying information. There are many things possible in M that can not be done in the interface. Strategy: The Power Query interface provides an easy way for you to write steps in the M programming language. I have to do something that the Power Query interface can not do.
0 Comments
Read More
Leave a Reply. |