I am trying to convert data manually, i am unable to do auto conversion with excel VBA. Can you please suggest to me as per image how to write a code in excel VBA to auto output with single click. I need data with one by one as shown an image. enter image description here
Asked
Active
Viewed 42 times
0
-
mind sharing what you had tried? – p._phidot_ Dec 11 '18 at 04:36
-
Possible duplicate of [Unpivot an Excel matrix/pivot-table?](https://stackoverflow.com/questions/32115219/unpivot-an-excel-matrix-pivot-table) – BigBen Dec 11 '18 at 04:54
-
https://stackoverflow.com/questions/36365839/excel-macrovba-to-transpose-multiple-columns-to-multiple-rows/36366394?r=SearchResults#36366394 – Tim Williams Dec 11 '18 at 05:14