I have an Excel sheet that one item per line:
Row 1 -- Item 1
Row 2 -- Item 2
Row 3 -- Item 3
I would like to import this into a sheet that looks like this"
Row 1 -- Item 1
Row 2 -- Sub Item 1-A
Row 3 -- Sub Item 1-B
Row 4 -- Sub Item 1-C
Row 4 -- Item 2
Row 5 -- Sub Item 2-A
Row 6 -- Sub Item 2-B
Row 7 -- Sub Item 2-C
The Smartsheet will be a template that I can use for different Excel Sheets.
I am looking for the best process to do this, so that I don't have to copy and paste each row from the Excel sheet.
Thank you for all your suggestions in advance.
