Hi! I am trying to expand rows of data based on a count in the cell. The cell shows how many employees are needed with a number per department (i.e. finance - 5, accounting - 4, operations - 2). Rather than listing the numerical indicator, I'd like for the table to expand to show 5 rows for finance, 4 rows for accounting, 2 rows for operations, etc. automatically when the table is pasted into Excel.
Solved by Z. S. in 30 mins