Copy/Move data that is 1 line item into new sheet as multiple line items
Help! I have been racking my brain trying to make this work, so not sure if this is even possible. Sorry if this is a bit confusing... After initial input into the form (with multiple required entries per line) I need to move the data into a sperate sheet (for excel export - to later be imported into PowerBi) as individual…