Copy/Move data that is 1 line item into new sheet as multiple line items

jacquedale

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 line items.

Smartsheet sheet would look like this...

But all items on this line item need to be "copied" to a sheet (that will later be exported via excel export - to later be imported into PowerBi), see below (sorry for all the redactions)- hope this makes sense

So bascially it would be the same as copying a row in excel and then pasting it as "transpose" (but the green items and one set of dark yellow/light yellow would become its own line item)

But the "receiving" sheet would have additional columns: as I need to also "count" quantity of finding, lines inspected...

Scott Orsey

There is no easy way to do this. I posted a solution to a similar problem about a year ago. It involves using an automation and the copy row feature. See the end of this post...

https://community.smartsheet.com/discussion/93956/looking-for-solution-for-forms-to-add-multiple-rows-to-a-sheet