Consolodating rows with the same primary column

Galadriel975

My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order.

So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing one line per order with the total quantity on the order. We were looking at incorporating a macro in excel, but ideally we would like to move into Smartsheet and bypass excel entirely.

Would there be any way to have the program auto consolidate these lines into one line in Smartsheet while also summing the quantities?

Andrée Starå

Consolodating rows with the same primary column

Galadriel975

Jul 31, 2024

My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order.

So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing one line per order with the total quantity on the order. We were looking at incorporating a macro in excel, but ideally we would like to move into Smartsheet and bypass excel entirely.

Would there be any way to have the program auto consolidate these lines into one line in Smartsheet while also summing the quantities?

---

View Post

Hi,

I hope you're well and safe!

Yes, probably using so-called helper sheet(s). I recently developed something similar for one of my clients.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!