andreslizcano
New Member
- Joined
- Jun 5, 2012
- Messages
- 2
Hello,
I have a table in which the rows represent cities and the columns represent certain characteristics/ attributes a city can have. In the cells every city & attribute pair receives a "grade"
City Eating Beach Ski
Barcelona 2 1 0
Chamonix 0 0 2
I would like to transform this so that every row represents a city & attribute pair and includes its corresponding grade.(I want to do this in order to be able to add more information about city- attribute pairs rather than about cities only)
City Attribute Grade
Barcelona Eating 2
Barcelona Beach 1
Barcelona Ski 0
Chamonix Eating 0
Chamonix Beach 0
Chamonix Ski 2
I am aware that I can use a pivot table to sort out all the pairs with a specific grade. and then I could paste this into a new table. But my data base (number of cities x number of attributes) is huge and I was wondering if there is no automatic process to make this transformation.
Thanks in advance
I have a table in which the rows represent cities and the columns represent certain characteristics/ attributes a city can have. In the cells every city & attribute pair receives a "grade"
City Eating Beach Ski
Barcelona 2 1 0
Chamonix 0 0 2
I would like to transform this so that every row represents a city & attribute pair and includes its corresponding grade.(I want to do this in order to be able to add more information about city- attribute pairs rather than about cities only)
City Attribute Grade
Barcelona Eating 2
Barcelona Beach 1
Barcelona Ski 0
Chamonix Eating 0
Chamonix Beach 0
Chamonix Ski 2
I am aware that I can use a pivot table to sort out all the pairs with a specific grade. and then I could paste this into a new table. But my data base (number of cities x number of attributes) is huge and I was wondering if there is no automatic process to make this transformation.
Thanks in advance