I have a table with values as such:
Category 1 Category 2
Value1 Value2 Value3 Value1 Value2 Value3
1 data11 data12 data13 data14 data15 data16.........
2 data21 data22 data23 data24 data25 data26
3 data31 data32 data33 data34 data35 data36
With about 50 columns of repeating data in different categories. I want to create a function that would allow me to make a pivot table without having to copy-paste. I was thinking of an offset function but i can't get it just right. I want a pivot table but don`t care how it`s made, maybe something like:
1 category1 value1 data11
2 category1 value1 data21
3 category1 value1 data31
1 category1 value2 data12
2 category1 value2 data22
3 category1 value2 data32
1 category1 value3 data13
2 category1 value3 data23
3 category1 value3 data33
etc...
Basically I want a function to join all the columns into one....then with corresponding observation, value (or column name/variable), and category. Any ideas?
Category 1 Category 2
Value1 Value2 Value3 Value1 Value2 Value3
1 data11 data12 data13 data14 data15 data16.........
2 data21 data22 data23 data24 data25 data26
3 data31 data32 data33 data34 data35 data36
With about 50 columns of repeating data in different categories. I want to create a function that would allow me to make a pivot table without having to copy-paste. I was thinking of an offset function but i can't get it just right. I want a pivot table but don`t care how it`s made, maybe something like:
1 category1 value1 data11
2 category1 value1 data21
3 category1 value1 data31
1 category1 value2 data12
2 category1 value2 data22
3 category1 value2 data32
1 category1 value3 data13
2 category1 value3 data23
3 category1 value3 data33
etc...
Basically I want a function to join all the columns into one....then with corresponding observation, value (or column name/variable), and category. Any ideas?