How to transform the excel data.

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

Developer

Common Use Cases

Accepted answers

Select tool to rename it to nothing

All comments

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

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

I need the output like below.

I

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

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

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

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:

How to transform the excel data.yxzp

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.

Select tool to rename it to nothing

Thanks for your help.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703