Hi,
I have two columns and I would like to do pivoting as follows:
Input:
| AC (column name) | VALUES |
| AC1 | 5 |
| AC2 | 10 |
| AC3 | 15 |
| AC1 | 20 |
| AC2 | 25 |
| AC3 | 30 |
I would like to get the output as:
| AC1 (column name) | AC2 | AC3 |
| 5 | 10 | 15 |
| 20 | 25 | 30 |
and so on.
Can you please let me know the configuration settings for this pivoting?
Thanks
Hello nakuld,
No Groups, Pivot is the AC (column name)-column, Manual Aggregation on VALUES, probably First.
Best,
Ferry
Hi Ferry
I could only get the first row values. For eg:
| AC1 | AC2 | AC3 |
| 5 | 10 | 15 |
But values in the second row and so on cannot be seen
You are absolutely right, sorry.
From your other post I know that you have your series numbered. Group on this numbering. The rest as stated above. That should work.
Best,
Ferry
Hi Ferry,
Sorry. I am still stuck.
What I did is made the iteration as you said
| AC | VALUES | ITERATION |
| AC1 | 5 | 0 |
| AC2 | 10 | 0 |
| AC3 | 15 | 0 |
| AC1 | 20 | 1 |
| AC2 | 25 | 1 |
| AC3 | 30 | 1 |
How to I configure it in pivoting?
Groups: ITERATION
Pivots: AC
Manual Aggregation: VALUES, method "First"