• 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

    Hui...

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

Transpose data

Hi,​
as here it's the Excel formulas section, are you sure you want some formulas ?​
 
Hii sir ,
This is very few raw of data but in reality this is big data i need power query or vba

PFA revised file

Regard
Rahul shewale
 

Attachments

  • Data%20Transpose2.xlsx
    11.5 KB · Views: 2
1] Here's a formula solution.

2[ Please see attached file and with described formulas using.

3] I added a 2nd Input / Output table 2 with more source data, the formulas used similarly just to change the cell range address.

Regards
Bosco
 

Attachments

  • Data Transpose2(BY).xlsx
    16.2 KB · Views: 9
Last edited:
Back
Top