Sometimes you get a list that's in a two column name value or attribute value format and need to split these multiline records into separate rows. If this were a small table you could do a copy/paste or create some formulas to pull out the name value pairs. If this were a recurring process you might even write some VBA. Well I'm no VBA guru but this can be done with Power Query and then be used again. If you get these type of tables often and have to perform these steps on a regular basis just overwrite or append the new data and refresh the query like it's magic! 🧙♂️
No comments:
Post a Comment