• 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

ambily chacko

New Member
can you help me on how to post 1column with 120 rows likewise 58 column with 120 rows vertically below one after the other.


  • chandoos.xlsx
    40.1 KB · Views: 3
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.


  • chandoo53404.xlsx
    206.6 KB · Views: 2