Rajeev Shah
New Member
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 ?
CarMakeJan SalesFeb SalesMar sales
HondaSedan200032001500
ToyotaSUV160019003400
NissanhatchBack210018001900
HyundaiVan320025001700
Thanks,
Rajeev
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 ?
CarMakeJan SalesFeb SalesMar sales
HondaSedan200032001500
ToyotaSUV160019003400
NissanhatchBack210018001900
HyundaiVan320025001700
Thanks,
Rajeev