Hii, I want to transpose data. Please help Regard Rahul shewale
R rahulshewale1 Active Member Aug 19, 2019 #1 Hii, I want to transpose data. Please help Regard Rahul shewale Attachments Data Transpose.xlsx 12.4 KB · Views: 7
Marc L Excel Ninja Aug 19, 2019 #2 Hi,as here it's the Excel formulas section, are you sure you want some formulas ?
R rahulshewale1 Active Member Aug 19, 2019 #3 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
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
B bosco_yip Excel Ninja Aug 19, 2019 #4 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: Aug 19, 2019
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