Data in columns to rows..

[Macao]

I have some data arranged like this:


week 1 week 2 week 3 week 4

a b c 50 60 70 80

d e f 2 3 4 5

g h i 44 45 46 47


But I would like to have it like this:


a b c week 1 50

a b c week 2 60

a b c week 3 70

a b c week 4 80

d e f week 1 2

d e f week 2 3

d e f week 3 4

d e f week 4 5

g h i week 1 44

g h i week 2 45

g h i week 3 46

g h i week 4 47


I'm not that familiar with loops yet, so I'll post my problem here while trying to work it out..


Hmmm.. the data does not seem to show nicely here, if someone can tell me how to modify the data for this post, I can make it look better.. I hope you can read it.

 

[TessaES]

I'd suggest using a Pivot-table for this.

 

[Macao]

But that does not work, because the weeks are arranged as columns like this:


Name Product Week1 Week2 Week3..


I want the data to be so that the "Week" columns are put in rows:


Name Product Week1

Week2

Week3


Again the example does not show correctly above, but pretend that "Week2" and "Week3" are exactly below "Week1" to get the point

 

[TessaES]

Add Name and Product to the row-area and the week columns to the data-area.

 

[Macao]

It actually worked, I had to give it a second try Thanks!!!