1 min readfrom 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

submitted by /u/laundrybases
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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