Hi, all. I have a table where I need to rearrange the data. The below is a small sample size. The real table is about 100 rows and 700 columns. The first table is what it looks like now, and the second table is what I'd like it to look like. Is there an easy way to do this. I tried pivot tables but it wasn't working right (for me). Would MS Access be a better tool? Although I'm not sure how to build the right query.
Any help would be greatly appreciated!!! Thanks!!!
Current Input
<tbody>
</tbody>
Desired Output (the headers in the top row can be any text as far as I'm concerned)
<tbody>
</tbody>
Any help would be greatly appreciated!!! Thanks!!!
Current Input
Qualifier | Model 1 | Model 2 | Model 3 |
A | 0.1 | 0.2 | |
B | 0.5 | 0.1 | |
C | 0.4 | 0.1 | 0.1 |
D | 0.6 | 0.1 | |
E | 0.3 | 0.5 |
<tbody>
</tbody>
Desired Output (the headers in the top row can be any text as far as I'm concerned)
Model | Qualifier | Value |
Model 1 | A | 0.1 |
Model 1 | B | 0.5 |
Model 1 | C | 0.4 |
Model 1 | D | |
Model 1 | E | |
Model 2 | A | |
Model 2 | B | |
Model 2 | C | 0.1 |
Model 2 | D | 0.6 |
Model 2 | E | 0.3 |
Model 3 | A | 0.2 |
Model 3 | B | 0.1 |
Model 3 | C | 0.1 |
Model 3 | D | 0.1 |
Model 3 | E | 0.5 |
<tbody>
</tbody>