•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
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#row zero
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#PO numbers
#split rows