•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combining texts in rows with a common value into a single row separated by commas
Our take
If you're managing invoices in Excel and find that product names are listed separately across multiple rows, you're not alone. Many users face this challenge, leading to confusion and inefficiency. Fortunately, there's a straightforward solution to combine these product names into a single cell or column on another sheet, separated by commas. This transformation not only simplifies your data management but also enhances your productivity. Let’s explore how to streamline this process and empower your data handling experience effectively.
Hello, 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?
This is how it looks like
I need like this
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Combining product information from multiple cells to one articulate product descriptionI have a few hundred rows of product information that is divided in different columns. What I want to have is an articulate product description in it's own cell from each of these products. From what I have gathered, the only option is to do this by hand, or possibly by the help of AI. Someone pointed out, that numerous.ai could be a good fit for this kind of problem, but the challenge is, that there is massive amount of data, so the tokens won't be enough for this kind of task. Could there be another solution? Excel-version: Office 365, 2601 Build 16.0.19628.20204 See example screen shot in comments. submitted by /u/Ayreonautical [link] [comments]
- Combining Multiple Text Cell with Added Characters and Filtering Out BlanksI use the file on the regular, but our vendor requires it in a specific format and that format can take a lot of time for the final column. Basically, I have anywhere from 1 to 12 text cells I need to combine and if there's another cell with text afterwards, they need to have "|" there to separate them. Let's say I'm looking to have A1 basically equal the text B1+ if C1 is not blank then +"|"& text of C1, then + if D1 is not blank then +"|"& text of D1 and so on until blank. I think I should have something like the below when done in the file A1=B1text|C1text|D1text|E1text A2=B2text|C2text|D2text A3=B3text A4=B4text|C4text|D4text|E4text|F4text|G4text and so on down the file I'm pretty familiar with excel and if formulas (not pivot tables though) but I just can't seem to make something work that still does not add a bunch of work afterwards. The closest in the past I came was something like the below but still ended up doing it manually in the end. A1=B1text|C1text|D1text|E1text|| A2=B2text|C2text|D2text||| A3=B3text||||| A4=B4text|C4text|D4text|E4text|F4text|G4text Any help would be very much appreciated. Please note that this is Excel 365. Edit1 : As multiple people have stated and solved this, my final formula has been as follows, =TEXTJOIN("|", TRUE, B1:M1). When I entered this the first time I noticed that the cell did not execute the formula and looked really close to the formula I had there currently (I just missed the |) and discovered that that column was formatted as text and once I changed it to general the formula executed properly. Thank you again for those of you that answered and will save me day of my life on this in the future. submitted by /u/Fun-Onion4302 [link] [comments]
- combining two columns into one without vstack or an arrayi 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 :') submitted by /u/nidoqueenofhearts [link] [comments]
- Merge data from multiple tables (data doesn't line up) into one tableHi. Combined table 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? https://preview.redd.it/h4alpwxp5dmg1.png?width=1424&format=png&auto=webp&s=e3088dd9a188827b6b541cca9ecd6904d924d259 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! submitted by /u/MasterpieceMaster371 [link] [comments]
Tagged with
#Excel alternatives for data analysis#rows.com#Excel compatibility#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#real-time data collaboration#real-time collaboration#row zero#Excel#products#invoices#combine#rows#cell#column#sheet#single row#separate