Accounting for missing Values & Transposing Data

[suds144]

Hello everyone,

I'm trying to account for missing data. This is my output

My output should be:

I've tried using the transpose and Filter function but am not getting the desired outcome. Thank you!

[atcodedog05]

Hi @suds144 

Can you please provide this data in an excel file.

Happy to help : )

[suds144]

Thank you

[atcodedog05 · Accepted solution]

Hi @suds144 

Here is how you can do it.

Workflow:

Hope this helps : )

[Akash__on · Accepted solution]

If you have data like this 👇 (as i am having it)

Then

1) use cleansing tool to replace any trailing or leading spaces.

2) use transform tool

3) use filter [value] !="Null"

4) Select tool to only use required fields

I hope this helps :)

[suds144]

Thank you so much!

[suds144]

Thank you so much! So helpful!

[atcodedog05]

Happy to help : ) @suds144 

Cheers and have a nice day!