Hi - Is it possible to use Multi-Field formula tool and copy value of the previous column in the empty columns.
Example:
RecordID | F1 | F2 | F3 | F5 | F6 | F7 | F9 | F10 | F11 | F13 | F14 | F15 | F16 | F17 | F18 |
1 | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ | XYZ |
2 | 2020 | 2021 | |||||||||||||
3 | Q1 | Q2 | Q3 | Q4 | Q1 | ||||||||||
4 | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan |
Here for RecordID 2 and 3 I want to fill the empty columns on the right with the previous columns value.
I am interested to use Multi-Field formula if possible.Thanks
Regards
Solved! Go to Solution.
Hi @anwerm2 ,
This is possible by using the multi-row with the help of cross tab and transpose tool.
Best,
Fernando Vizcaino