Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
ionela24
 | Femeie
24 ani
Prahova
cauta Barbat
25 - 47 ani |
|
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 869
|
|
Instead of going through Pivot/Unpivot Columns, I just need 3 a few values to be loaded onto the even rows instead of the odd ones.
I have the value on row 1 (index 0) and the quantity on row 2 (index 1).
I just want the quantity on the same row as the value.
1. First, add an Index column (Add Column - Index Column)
2. Then add a Custom Column, and use a formula similar to:
| if Number.Mod([Index], 2) = 0 then #"Added Index" [intrari] { [Index] + 1} else null) |
Number.Mod([Index], 2) = 0 checks whether the value in index column is divisible by 2 (even number)
#"Added Index" is the previous step - since you also probably just added the Index column, it should be the same.
[intrari] is the column that contains, on odd rows, the value I want moved to even rows
{ [Index] + 1} is the way you refer to the Next Row
Source:
|
|
| pus acum 3 zile |
|