•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
combining two columns into one without vstack or an array
Our take
If you're working with two separate columns of names across different sheets and want to combine them into a single, sortable column without using vstack or arrays, there are effective methods to consider. One approach involves using a combination of traditional formulas, like `IFERROR` and `VLOOKUP`, to pull in unique names from both sheets while maintaining flexibility for sorting. This ensures that your less tech-savvy coworkers can easily manage and manipulate the data without encountering complex functions. Let's explore practical solutions to achieve this seamlessly.
i have two columns of names on two separate sheets of a workbook. on a third sheet, i want to combine all of the (unique, but that part is easy) names into one column. from there, some vlookups nested in iferrors pull in additional from whichever sheet the name came from (looks for the name in the larger spreadsheet; if it's there, do the vlookup, but if there's an error, check the smaller sheet and do the vlookup).
vstack does this nicely, but because it returns an array, i can't use basic sorting anymore. the sort function exists, but we want to be able to do different sorts at different times and this sheet is for use by my less tech savvy coworkers, so i can't rely on that. a recommendation of =query1 & query2 was attempted but i ended up with the first row of each spreadsheet in one cell.
please let me know if anyone else has ideas! i've been googling but keep hitting walls :')
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- join content from cells in a column without losing content from the corresponding columns.basically how do i make the highlighted screenshot look like the unhighlighted one but with a function for a spreadsheet with like 170k rows. sorry that this is in sheets. im trying to figure out if what i need is to buy excel basically what i want is to condense duplicative info while listing/joining the different pieces, all controlled for case number. https://preview.redd.it/4rfjrucnjdzg1.png?width=1408&format=png&auto=webp&s=ff424cf0a8553fe30b769986169901c1ca25a3bd https://preview.redd.it/c8mtq58ojdzg1.png?width=1080&format=png&auto=webp&s=21ccbdfd8ae8d41eb2d69368e62163df3737088b submitted by /u/Abi-Ankeney-PMM [link] [comments]
- How to sum all cells in column B where column A in the same row contains a specific string of text?I have a spreadsheet with names in column A and numerical responses in columns B, C, etc. I want to make it so that if, in a given row, column A contains a specific name (say, "Bob"), then the numerical value in column B in that same row will be added. Basically, I want the sum of all the rows in column b for which column a contains "Bob". I can't just sort by column a because sometimes it will contain multiple names per cell (ie Susan, Bob), and I need the equivalent numerical value to be added to both Bob and Susan's total. I've tried google searching this but I can't figure out how to specify same row but different column. I know I could probably do this with what I know already using just like... a lengthy chain of conditionals, but last time I tried that I ended up with an excel file that crashes my computer every time I try to open it, so I was hoping there's a better option. This is Version 16.85 on a Mac btw. submitted by /u/Odd_Nectarine6622 [link] [comments]
- Combining texts in rows with a common value into a single row separated by commasHello, in my Excel file I have the products sold on invoices, but these products are listed separately in different rows. For example, if an invoice contains 5 products, they are written in 5 separate rows in Excel. What I need is to combine only the product names into a single cell (or column) on another sheet. I don’t know how to do this and I’ve been struggling with it for a long time. Could you please help me? https://preview.redd.it/uimcs81ds5vg1.png?width=293&format=png&auto=webp&s=dd5b74a78012f949b45e9288daa23238e229210e This is how it looks like https://preview.redd.it/nfljte9ls5vg1.png?width=386&format=png&auto=webp&s=c6dc4eb7f5a2393b340feee3947958e4eaf9c80a I need like this submitted by /u/afluenza23 [link] [comments]
- Using Data from Two Sheets to find classesI work in a corporate job and somehow became the person on my team that knows excel best. I’m okay with excel. Not an expert. But I need help. I have a spreadsheet that lists available training classes and how many seats the class has and how many are still available. I also have a sheet of learner requests for classes. I would love to combine the data and be able to query or pivot to show a list of students that could be enrolled into available classes. What’s the best method of going about that? Thanks. If I need to go elsewhere to ask questions like this please direct me. Thanks. submitted by /u/Coffee4words [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#rows.com#Excel compatibility#google sheets#row zero#financial modeling with spreadsheets#Excel alternatives