Hi Alan,
Please see attached file. I have indicated which columns need to remain intact and which need to be converted vertical.
Thanks for your help.
Rajeev
Hi All,
I have data in horizontal format and need to change same into vertical format.
Please see example below.
I would like to keep the columns " Car" & "Make" intact but change " Jan Sales" , " feb sales" & " Mar Sales" into rows. ( vertical format )
is there a macro or formula for same ...
Hi All,
Please see attached spreadsheet.
I want to allocate car units for different companies between 4 cities ( Mumbai ,Kolkatta, Chennai & Delhi ).
Conditions are ,
* total sales for the cities ( between different car companies )should equal to the number
shown in Row 13
* total...