Sort columns independently?

Greetings.. newbie here.

I have a table that lists out the people with about 100 different skills, but there are many blank cells in between names for each skill so it's not very readable.

What's a good way to remove these blank cells independently for each column? Thanks!

Transformation

Accepted answers

OllieClarke

Hi @ozdogand If you transpose your columns, then you can filter out the empties, create a new rowid and then cross-tab the data back

Hope that helps,

Ollie

empties.yxmd

All comments

echuong1

Each row is not meant to represent a separate record, correct?

If that is the case, I'd suggest isolating each column (field) using a select tool and then using a filter tool to remove all of the blank/null rows out. You can then use the join multiple too with "join by record position" as the configuration.

See attached for an example. Let me know if that works!

New Workflow3.yxmd

ozdogand

I should have mentioned that there are about 100 skill columns. do you still think that's the way to go? Thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703