•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combine Tab data into one?
Hi,
I currently have a workbook with 3 tabs. Two of the tabs I'm downloading data and pasting into every day and with the other I'd like it to combine the data from the two tabs into. They mostly share the same column headers but each have a few unique headers. In that scenario I'd like the columns in the third tab and to remain blank if it's coming from a tab without that column. Pasted below is an example. I don't want the tab names listed, just listing as example to show where they're being pulled from. What would be the best way for me to accomplish this?
| Tab 3 |
|---|
| Tab1-A |
| Tab1-B |
| Tab1-C |
| Tab2-A |
| Tab2-B |
| Tab2-C |
Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#workbook
#tabs
#data
#combine