How to transform the excel data.

[TANIJD2021]

Hi,

I have a excel data as an input in the form as attached.

I want to have firstname and all the columns after that start at row 3.

Can someone please help me.

Thanks,

Tanika

[alexnajm]

I would put down a Filter to do [FirstName] != Null()

[TANIJD2021]

I loose my count data after I apply "[FirstName] != Null()" filter.

I need the output like below.

I

[alexnajm]

Ah ok that was not clear before - seeing the expected output helps.

If you provide the data, I can build out a workflow.

[TANIJD2021]

The data could be simple like 

Count	FirstName	LastName
54	Null	Null
43	Null	Null
Null	Aaliya	David
Null	John	Sutton

output should be

Count
54
43
FirstName	LastName
Aaliya	David
John	Sutton

[alexnajm]

That works - its still better than replicating a screenshot 😂 even then, still had to create an Excel to use the input functionality I wanted. Here it is:

[TANIJD2021]

Thanks for your help

But when I output it into excel, i got the below view. Is there  a way to remove f3 heading after count.

[alexnajm · Accepted solution]

Select tool to rename it to nothing

[TANIJD2021]

Thanks for your help.