•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com