Hi guys,
I have to transpose values, and it should be easy, but when using Index match match function i get the same values all over again
| central| hour1| hour2 | hour3 |hour4| hour5 | hour6 |hour7| hour8 | hour9 | and so on till hour24
| a | 1| 4 | 20 |
| b | 2 | 5 | 20 |
| c | 3 | 5 | 20 |
| a | 3| 4 | 30 |
| b | 5 | 5 | 50 |
| c | 3 | 5 | 0 |
to |hour| a|b|c|
|hour1|1|2|3|
|hour2|4|5|5| and so on untill hour24, and then again for the new day I hav to do it again in the same row
|hour1|3|5|3|
|hour2|4|5|5| and so on for the whole year.
I hope i managed to explain my problem. Any kind of help would be appreciated, I just started with excel.
Cheers
I have to transpose values, and it should be easy, but when using Index match match function i get the same values all over again
| central| hour1| hour2 | hour3 |hour4| hour5 | hour6 |hour7| hour8 | hour9 | and so on till hour24
| a | 1| 4 | 20 |
| b | 2 | 5 | 20 |
| c | 3 | 5 | 20 |
| a | 3| 4 | 30 |
| b | 5 | 5 | 50 |
| c | 3 | 5 | 0 |
to |hour| a|b|c|
|hour1|1|2|3|
|hour2|4|5|5| and so on untill hour24, and then again for the new day I hav to do it again in the same row
|hour1|3|5|3|
|hour2|4|5|5| and so on for the whole year.
I hope i managed to explain my problem. Any kind of help would be appreciated, I just started with excel.
Cheers
