This video uses a simple and power Excel index formula to assist in transposing data with a N rows pattern. Please see the video and
Category: Data Transformation
Clean data headers with Excel and Power Query
Hi, in this post, we are using Excel transpose function and Power Query to clean up our data headers to the format that we want.
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 