Hey Guys,
I need some help to figure out an epression that I should use at multirow formula to get result below
Input:
Value |
A |
B |
C |
D |
E |
F |
Output:
Value | ID |
A | 1 |
B | 1 |
C | 2 |
D | 2 |
E | 3 |
F | 3 |
Solved! Go to Solution.
Here's the formula:
IIF([Row-2:ID]==[Row-1:ID],[Row-1:ID]+1,[Row-1:ID])
You need to set "Num Rows" to 2 in the configuration.
Cheers,
Mark