New Excel Video...combining multiple rows for the same item into a single row with the related values placed into separate columns. The example I use is multiple customer comments for a set of products. For this video I used Power Query.
youtu.be/5BKsdHsNtuo
youtu.be
Excel: Combine Multiple Rows into Separate Columns with Power Query
YouTube video by Mike Thomas