Stack Adjacent rows into one column & bring column headers

Topic

New Reply

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

Reply | Quote

Replies

I copied the top 2 rows.
Right clicked on a cell in column A and selected Paste Special, Transpose.

Seems to be what you are after.

cheers, Paul

Reply | Quote