Hi Team,
I am kind of lost between Transpose and CrossTab here
Input Data
| ColumnName | Value |
| A.1.a | 11 |
| B.1.b | 22 |
| A.2.a | 33 |
| B.2.b | 44 |
| C.2.c | 55 |
| D.2.d | 33 |
| A.3.a | 22 |
| B.3.b | 44 |
| C.3.c | 55 |
| D.3.d | 66 |
I need to Transpose or CrossTab it to below form
| A | B | C | D |
| 11 | 22 | ||
| 33 | 44 | 55 | 33 |
| 22 | 44 | 55 | 66 |
Solved! Go to Solution.
Woohhoo Solved it. Got that number in between as column and then group by using CrossTab
