Hello, I have a 12 month employee schedule. The days are the headings for each row and the employees are in each row by date.
I need to have all of the rows moved to one column and ensure their assigned work date is brought over as well.
I’ve figured out how to copy all of the rows into one column using the fill function. But stumped when bringing over the correct date. I’ve attached a sample showing desired results. Thank you