I’m trying to create an inventory system for my business. For example, our SKU codes start with "LMS" "RSP" and "CON" for specific locations where we’re working. I’m trying to take all unique "LMS" codes, and copy them to a single sheet from our raw scan data. I’ve tried variations on REGEXMATCH, and UNIQUE, and… Read More I can't figure out how to transpose unique values based on specific critera in Google Sheets

I am trying to replace an obsolete Excel report currently used for sales forecasting and inventory projections by our supply chain team and I am using R for this. The desired output is a data frame with one of the columns being the projected closing inventory positions for each week across a span of N… Read More Inventory Projection Calculation in R