Multi- row Formula

[mzlee]

Hello, 

I joined different files with a common sheet and I am looking to join everything per type.

After joining After joining all the sheets on the left column this is how data looks now, but I need it to look like the left. There are so many sheets and was hoping I can use the multirow formula but I might be setting it up wrong.   

[CoG · Accepted solution]

You can create a new column with the Multi-Row Formula Tool called "SortID" with the formula:

IF [Type] = "Type" THEN 0 ELSEIF [Type] = "Unreconciled items" THEN 3 ELSEIF [Type] = "Reconciled items" THEN 7 ELSEIF [Row-1:Type] = "Unreconciled items" THEN 4 ELSEIF [Row-1:Type] = "Reconciled items" THEN 8 ELSEIF IsNull([Type]) || [Type] = "" THEN 12 ELSE [Row-1:SortID] ENDIF

Next sort on [SortID] Ascending, and you should get something similar to what you are looking for although some extra cleanup and formatting will be necessary to get rid of extra stuff, but this formula should make doing so quite simple.

[Qiu]

@mzlee 
I copied the Formula of @CoG  and it works.
I just have to add some filter to remove the duplicated "Reconciled items" and "Unreconciled items" rows.

[mzlee]

thank you both! it worked!