Data Tool for cleaning Excel.

0 votes
asked by about Microsoft Office Excel
edited by

I am looking for a tool which allows me to point to an Excel workbook, and highlight three separate dimensions, i.e.: X Axis (Column A = StoreName, Column B = StoreNum), Y Axis (Row 2 ProductName and Row 3 = Product Code and Z Axis (Quantity). Then create a new clean sheet for this. Would like a widget which asks: "Which products do you want kitted together/?". Any ideas?

1 Answer

0 votes
answered by (264k points)

I've searched for a tool to fit your needs, but it appears there is nothing available to do exactly what you need. However, there are some tools available that you can try to see if they'go, but if it turns out there are useless, then you will have to achieve this with the help of Macro scripting.

As an example, use the following one to start with: https://xltools.net/data-cleansing-in-excel/

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...