I have Data Like below
Col A | Col B | Year | JAN | FEB | MAR | APR | MAY |
Chair | Office | 2021 | 10 | 20 | 30 | 40 | 50 |
Chair | Office | 2022 | 30 | 40 | 50 | 60 | 70 |
Pencil | Library | 2021 | 15 | 25 | 35 | 45 | 55 |
Pencil | Library | 2022 | 25 | 35 | 45 | 55 | 65 |
And I want the output like below
Col A | Col B | Date | Value |
Chair | Office | Jan-2021 | 10 |
Chair | Office | Feb-2021 | 20 |
Chair | Office | Mar-2021 | 30 |
Chair | Office | Apr-2021 | 40 |
Chair | Office | Mar-2021 | 50 |
Chair | Office | May-2021 | 60 |
help me in achieving this
Solved! Go to Solution.
Hi @kiotsuresh
One way of doing this:
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.
Thank you, I have an another scenario,
Data Like this ,
Name | Account | date | value |
suresh | 100 | Jan-21 | 1 |
suresh | 101 | Jan-21 | 2 |
suresh | 102 | Jan-21 | 3 |
suresh | 100 | Feb-21 | 4 |
suresh | 101 | Feb-21 | 5 |
suresh | 102 | Feb-21 | 6 |
Need Output like this.
Name | date | 100 | 101 | 102 |
suresh | Jan-21 | 1 | 2 | 4 |
suresh | Feb-21 | 4 | 5 | 6 |
Can you please help with this
Hi @kiotsuresh
Check the attached workflow
If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)
Thanks.