Do you want all the roles in a single cell or just all the columns consolidated to the minimum number of columns, i.e deleting all the blanks in each row?
The latter.
That's easy then, select entire sheet, ctrl+G, special,blanks, delete, shift left
@hugo7 started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Do you want all the roles in a single cell or just all the columns consolidated to the minimum number of columns, i.e deleting all the blanks in each row?