Minstrel
09-27-2007, 01:35 AM
I have a spreadsheet with 3000+ rows of data.
I need to be able to change the layout from horizontal to vertical
In the first column, I have a category. The next 6 columns are months (Jan 2007 to June 2007).
Each category has a value in one or more months.
I want to show this as 2 columns: Category in the first column and Monthly Spend in the next. So there would be 6 rows for each Category rather than 6 columns.
I've tried using Transpose, but with so much data it's taking a loooooong time. :(
Can anyone suggest code solution? :think:
Thanks in advance
I need to be able to change the layout from horizontal to vertical
In the first column, I have a category. The next 6 columns are months (Jan 2007 to June 2007).
Each category has a value in one or more months.
I want to show this as 2 columns: Category in the first column and Monthly Spend in the next. So there would be 6 rows for each Category rather than 6 columns.
I've tried using Transpose, but with so much data it's taking a loooooong time. :(
Can anyone suggest code solution? :think:
Thanks in advance