In the process of flattening a JSON file I wound up with a table that had duplicates in some cells but not others. See Below:

PowerQuery created a duplicate for ID, Name, City, and Age for every friends.name. How do I consolidate the friends.names into a single row and delete the duplicates? Thank you!

​In the process of flattening a JSON file I wound up with a table that had duplicates in some cells but not others. See Below:PowerQuery created a duplicate for ID, Name, City, and Age for every friends.name. How do I consolidate the friends.names into a single row and delete the duplicates? Thank you!     Read More

​