Sort columns independently?

[ozdogand]

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!

 

[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!

[ozdogand]

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

[OllieClarke · Accepted solution]

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

[ozdogand]

Brilliant.  Thanks!