• 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.

Transpose data into another WS

Hi All,

I have installments paid by customers in horizontal format for each apartment sold that I need to convert to vertical format. The format for each unit is fixed containing 17 rows e.g unit 1 is from row 1 to row 17, unit 2 from row 18-34...........................

I have attached spreadsheet with Input tab (that contains the existing horizontal format) & Result tab that contains desired outcome.

Can you please help with the code or formula whatever is optimal. I tried to search but couldn't find the solution that can help.