Thread: [Solved] Extract data from many cells into 1 cell
View Single Post
 
Old 06-09-2023, 02:33 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 872
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
With Excel 2016 you have Power Query built-in so in the attached, you can change the data in the blue table on the left, then right-click the green table on the right and choose Refresh, to update the results.


2023-06-09_103056.jpg
Attached Files
File Type: xlsx msofficeforums50958.xlsx (16.9 KB, 3 views)
Reply With Quote