Expression for column that lists empty columns

[Mbolamu]

I have two tables: Table 1 & Table 2.

Table 2 has 4 columns :

Column: A 

Column: B

Column: C

Column: D

Id like to create an expression in Table 1 that lists that name of the columns in table 2 that are empty within that row.

In the example table below, “XXXX” represents the data. The column in table 1 shows the names of the columns in table 2 with no data in that row. 

 

I am a novice and haven it a good crack with the following expression:

LIST(
IF(
AND(
CONTAINS(
Table2[ROW ID],[_THISROW].[ROW ID]), TRUE,
ISBLANK(
Table1[A]), TRUE), “ A”, “”),

IF( 

AND(
CONTAINS(
Table2[ROW ID],[_THISROW].[ROW ID]), TRUE,
ISBLANK(
Table1[B]), TRUE), “ B”, “”),

IF(
AND(
CONTAINS(
Table2[ROW ID],[_THISROW].[ROW ID]), TRUE,
ISBLANK(
Table1[C]), TRUE), “ C”, “”),

IF(
AND(
CONTAINS(
Table2[ROW ID],[_THISROW].[ROW ID]), TRUE,
ISBLANK(
Table1[D]), TRUE), “ D”, “”))

Any help would be much appreciated!