I'm creating a import template to another system from an existing excel report. The existing excel report includes a list of employee names in rows with hours split across multiple columns however, the import template requires the data to be imported by row which will requrie multiple rows for each employee name. Is there a formula I can use to take the data from columns, populate it as rows and repeat the common data (name, number etc) for each row of unique data? I saw a thread using index formulas but couldn't quite get it work for me. I've attached the workbook, it has minimal data for testing, in a completed report there could be 30 columns and 150-200 rows.
thanks
Bookmarks