•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to split CERTAIN cells into separate nearly identical Rows
Our take
If you need to efficiently split cells containing multiple PO numbers into separate rows while maintaining uniformity in the associated data, you’re in the right place. This task requires a formula or script that can take rows with multiple entries and transform them into distinct rows for each PO number. For instance, if a row lists PO numbers 7919147 and 7919158, the catalog number, manufacturer, and vendor details will remain unchanged, creating a streamlined dataset for better analysis. Let’s explore how to achieve this effectively.
So I need a formula/script that can take the rows that have multiple PO numbers listed and split them into separate rows so that all of the data is uniform.
All of the data in the other columns stays the same, just the PO numbers would each become their own row. For example: in the 2nd row, for the PO numbers 7919147 and 7919158 the catalog number for both would be DCHN-22-, Manufacturer would be Cook Inc, Vendor stays Cook Inc, etc
I believe it is a simple fix my brain just can't figure it out today, thank you in advance (and hopefully I worded it well enough for smarter people to figure out lol)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need a SPECIFIC type of number to be extracted from 2 columns and placed into 1Co-worker needs help cleaning up some data (that they get once a month so not a one-off) where he naturally wants all of the PO Numbers to go into the PO Number column he added. The issue is whoever is originally putting this data together puts the PO numbers in one of two columns (or as often, not at all) so I want to help him write a formula/macro/script that will extract the PO numbers from these 2 columns and combine them into one. Sounds simple enough but the problem is I ONLY want it to extract PO numbers, which are the ones that begin 01001- and to leave everything else. And as you can see they show up in either column along with a bunch of numbers no one cares about. Is there an easy way to accomplish this that I am missing? Thanks in advance https://preview.redd.it/3qfu9zoy4gng1.png?width=290&format=png&auto=webp&s=510c06fd113fe29a4f1287a53a4af310f317848e submitted by /u/coletrain2481 [link] [comments]
- How To Group Multiple Rows?Hoping someone has a good tip for this. I have an excel sheet with 14,035 rows of data and 466 columns of data. Many rows share a common order number or common address. What is the best excel feature to group these rows and maintain all 466 columns? I’d like a heirarchmal grouping if possible, first by order number then by address. I’ve tried Power Query, get from Table but I can’t quickly convert this much data into a table. We have customers with multiple address booked under a single order number - order number is at the customer level. at each address there may be multiple products. I need a way to quickly answer these types of questions… -How many customer order numbers are there? -What % of address locations have XYZ mix of products? -How many address locations have multiple products? and what are the products? -What is the age of the individual products? submitted by /u/Impossible_Equal_642 [link] [comments]