I need some help. I have a sheet (Sheet 1) that will have a list of ids and items in them.
In another sheet (sheet 2), I have a list of 5 steps that need to be done to each of the ids/items in sheet 1.
In sheet 3, I want to copy the steps (it's a set number) however many times an unique id is present in sheet 1.
Sheet 1 table:
Sheet 2 table:
|Enter Description here||1.0||A|
|Enter Manufacturer here||2.0||B|
|Enter Requester here||3.0||C|
Sheet 3 should end up looking like this: (Sheet 3 can start with a blank table with just the header)
|1A||Chair||Enter Description here||1.0||A|
|1A||Chair||Enter Manufacturer here||2.0||B|
|1A||Chair||Enter Requester here||3.0||C|
|1B||Table||Enter Description here||1.0||A|
|1B||Table||Enter Manufacturer here||2.0||B|
|1B||Table||Enter Requester here||3.0||C|
Is this possible? Can anyone please help?
Thanks in advance!