•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Merge data from multiple tables (data doesn't line up) into one table
Hi.
If I want to create a table like the top image from the data of the tables from the bottom image (the data from the bottom right corner), is there an easy way to do it? Where it also updates automatically if the data changes?
The way I am currently doing it is literally going =then selecting the cell one by one. I wouldn't mind if it was a few recipe or items, but their are hundreds. Please help. Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#Excel compatibility
#combined table
#merge data
#data merging
#automatic updates
#data tables
#table creation
#data change
#data processing
#cell selection
#Excel functions
#source data
#cell references