I have a worksheet with 5 columns (ID, Cost Center, GL Account, GL Account Desc, and Action) and 337 rows, three of the columns are static (ID, Cost Center, and Action) and have the same data in all 337 rows.
I have another worksheet with 1 column (Cost Center) and 109 rows of unique values.
I need to take the Cost Center value from the second worksheet and place it in the Cost Center field of the first worksheet. The way it would look is one cost center would be listed 337 times because there are 337 unique GL Codes, that need to be linked to that one cost center.
The worksheet would grow 337 rows multiplied by the unique 109 cost centers.
I don't know how to do this or if it can be done in Excel. Please help.