Forum Discussion
Converting columns to rows
Hi all, I am trying to covert a file which is similar to the below to the below format Thanks, Kumar
Use the Transpose feature: https://support.office.com/en-us/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419F2E3-BEAB-4318-AAE5-D0F862209744
Alan, I don't think transpose works here. With it you'll have 4 regions columns with month/sales rows.
Actually we need here to combine all months and sales columns into one pair of columns with months and sales.
