Need Your urgent help.

[alt_tush]

Hi Team

I have below data where currency code is mentioned in the row. I want to make it separately month wise.

Field1                      Field2

Currency Code            AED
Jan                             1
Feb                            2
Mar                            3
Currency Code         ARS
Jan                           4
Feb                           5
Mar                          6
Currency Code       TRY
Jan                          7
Feb                         8
Mar                         9

I want below output

Field1  Field2   Currency Code
Jan     1           AED
Feb     2          AED
Mar     3         AED
Jan     4         ARS
Feb    5          ARS
Mar    6         ARS
Jan    7         TRY
Feb    8        TRY
Mar    9        TRY

Need your urgent help.

Thank you.

[JohnJPS]

I would do a MultiRow formula with a function that analyzes [Field 1]...

IF [Field 1]=="Currency Code THEN
[Field 2]
ELSE
[Currency Code:Row-1]
ENDIF

After that you can filter out where [Field 1]=="Currency Code"

Hope that helps.