Data Formatting - Weird columns

[sriniprad08]

Hi Team,

I need help. I have a dataset which has no column names . Please find attached the input and the desired output.

Please let me know your thoughts,

Thanks,

Sr

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is how you can do it.

Workflow:

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you so much for the help :)

Cheers,

Sri

[sriniprad08]

Hi @atcodedog05 ,

Need one more help please. There are couple of rows for "Site_new" which is blank but the corresponding indicator is currently "0". Is it possible to change it to 1 where ever the Site_new is blank?

thanks,

Sri

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Please find the updated workflow

Hope this helps : )

[sriniprad08]

Hi @atcodedog05 ,

Thank you again :)

Cheers

[atcodedog05]

Happy to help : ) @sriniprad08 

Cheers and have a nice day!