• Stack Adjacent rows into one column & bring column headers

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Stack Adjacent rows into one column & bring column headers

    • This topic has 1 reply, 1 voice, and was last updated 11 months ago.
    Author
    Topic
    #2458439

    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

    Viewing 0 reply threads
    Author
    Replies
    • #2458448

      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

    Viewing 0 reply threads
    Reply To: Stack Adjacent rows into one column & bring column headers

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: