Print multiple copies of the same data on a sheet based on a value in another column
Posted: Tue Dec 03, 2019 2:28 pm
I'm using an ERP software to make an inspection log. The data the report pulls from will have a piece mark with a given quantity associated with it. I'd like to print a separate row for each piece mark in the event that one typical piece of an assembly may pass while another can be marked as failed.
This would translate:
{MainMark} - {Quantity}
B1001 - (1)
B1002 - (2)
B1003 - (1)
To This:
B1001
B1002
B1002
B1003
Is there a specific function or command that will allow me to extract the data in such a way?
This would translate:
{MainMark} - {Quantity}
B1001 - (1)
B1002 - (2)
B1003 - (1)
To This:
B1001
B1002
B1002
B1003
Is there a specific function or command that will allow me to extract the data in such a way?