• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

shortcut to paste column vertically


Well-Known Member
See table at cell E1 of the sheet format needed of the attached.
Tt's a Power Query solution which unpivots the data. It includes blanks as you have in, for example, cell C243. If you don't want this then remove the ReplacedValue step from the query.
If you change the source data on sheet data, you'll need to refresh the result table by clicking on it somewhere and choosing Refresh, or click the Refresh button in the Queries & Connections section of the Data tab of the ribbon.