Forum Discussion
How to Auto Fill Column Titles With Row Text
Hello community, I am faced with a couple hundred files which are to be imported to Power BI and I must rename the columns based on the 2rd row in each sheet. What is the best way to automate th...
Please check out this video with instruction on how to integrate M-code into your solution:
When I entered the exact formula you posted it gives me an error message and then the entire sheet disappears. I'm sure I have to do some changes to the formula but why would it disable the entire sheet if I type it in wrong?
Sorry, but I don't understand what you mean with sheet. Could you please clarify?