Record display

[jmedidi]

Need some help to display the existing records as mentioned below:

Files	Calibration	Warnings	DV_Testing_completion_date
Yes
No
n/a
	06.00.05
	033.44.33
	112.3.45
		Yes
		No
		n/a
			12-Jun-20
			8-Aug-20
			21-Jan-22

Desired

Files	Calibration	Warnings	DV_Testing_completion_date
Yes	06.00.05	Yes	12-Jun-20
No	033.44.33	No	8-Aug-20
n/a	112.3.45	n/a	21-Jan-22

[MatthewO]

Hi @jmedidi - I believe the attached workflow will give you desired results.

[Thableaus]

See flow attached.

Cheers,

[atcodedog05]

Hi @jmedidi 

My take on this works best if you have only 4 columns.

Workflow:

Hope this helps : )

[jmedidi]

I have more than 4 columns

[messi007]

@jmedidi,

Please see below :

Attached the workflow,

Regards,

[jmedidi]

Works well. But i see lot of blank rows below after the contents moved. I tried Data cleansing tool to remove Null rows but looks like it doesn't work to remove the blank rows. also i can also use filter to remove empty rows but there are more than 60 fields to work.

[gabrielvilella]

You can filter on one field that if that one is blank, you know that all the other are blank and should be removed. Or if you want to use the data cleansing too, you can have a multi field formula before like this:

IF IsEmpty([_CurrentField_]) THEN Null() ELSE [_CurrentField_] ENDIF