•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
The grocery list breakout anomaly
Let’s say in column A, I have multiple groceries. (E.x Bread, eggs, cheese, milk) In column B, I have Qty’s needed
So for instance, 1 bread, 2 eggs, 3 cheese, and 4 milk.
In column C my intention is to break out the list, so I want cell C1 to say bread, cells C2 and C3 should be eggs, Cells c4:c7 should be cheese etc.
What’s the appropriate function(s) if I don’t want to encounter a #spill?
Thanks all
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#automated anomaly detection
##spill
#excel
#column
#cell
#function
#break out
#qty