Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2023, 02:33 AM
p45cal's Avatar
p45cal p45cal is offline Extract data from many cells into 1 cell Windows 10 Extract data from many cells into 1 cell Office 2019
Expert
 
Join Date: Apr 2014
Posts: 963
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, 5 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
filling in blank cells with data from cell above RayK Excel 1 01-12-2017 04:14 PM
Extract data from many cells into 1 cell Combining several cells data into one single cell H28Sailor Excel 6 01-09-2017 06:00 AM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 bobznkazoo Excel 2 03-27-2014 11:14 AM
How can I fill the below emty cells with above cell data? Learner7 Excel 8 06-28-2011 12:10 PM
Extract data from many cells into 1 cell How to combine different cells data in one cell? Learner7 Excel 1 07-28-2010 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft