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!
Solved! Go to 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 :)
Thank you so much!
Thank you so much! So helpful!
Happy to help : ) @suds144
Cheers and have a nice day!