Replacing empty value with previous value with group by criteria

[reignM]

Hi Hello. I have this table record below. 

ID	Digital	Industrial	Intralogistics
6129740673d	Big Data	Machinery
6129740673d	Cloud Computing
6129740673d	Cyber Security
63018356c37		3D Modelling	Logistic IT
63018356c37			Space Solution
69562a28468	Product Development

I would like to fill the empty rows with the value above while grouping by the ID. So for example, 'Machinery' to exist on all 3 rows of 'Industrial' where 'Digital' exists for ID 6129740673d . Similarly, for 'Industrial' column for ID 63018356c37.

Hence: 

ID	Digital	Industrial	Intralogistics
6129740673d	Big Data	Machinery
6129740673d	Cloud Computing	Machinery
6129740673d	Cyber Security	Machinery
63018356c37		3D Modelling	Logistic IT
63018356c37		3D Modelling	Space Solution
69562a28468	Product Development

I tried using Multi-Row Formula with reference to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/replace-null-value-with-last-previous-... . It works but it only affects one column each time.

' if IsEmpty ([Digital]) then [Row - 1: Digital] else [Digital] endif '

Considering that I have more than 8 columns, I'm hoping there is a more feasible approach. 

[AkimasaKajitani · Accepted solution]

Hi @reignM ,

In this case, to proceed with some fields as the same process, you can do it to have the data on the vertical using Transpose tool.

This is the result and setting of Multi-row formula tool.

After that, you can do it to the original form using Cross Tab tool.

[reignM · Accepted solution]

It works! Thank you very much!