I have what I thought was an easy thing to do, but struggling.
I have a table of many rows and columns. Within this table are many individual words spread out, but also lots of blank cells the content of which is dynamic and will be changing, something like this:
I'm trying to create a new table below it which removes all the empty cells, and ideally puts each column into alphabetical order, something like this
My range is AD62:CI89 and this is fixed, so there's only ever going to be 28 rows, and there will be a maximum of 8 articles in the end for each column. There's no relation between each column, so loosing the empty cells won't bother me. The important thing is to keep the columns separate.
I'd assumed I could used filters to remove empty cells, but I can only work out how to filter on one column, and that hides the information from the other cells too!
HELP!
I have a table of many rows and columns. Within this table are many individual words spread out, but also lots of blank cells the content of which is dynamic and will be changing, something like this:
apple | sausage | ||||
berries | pasta | hot dogs | |||
cheese | cereal | toast | |||
avocado | sandwich | chips | |||
beef | brioche |
I'm trying to create a new table below it which removes all the empty cells, and ideally puts each column into alphabetical order, something like this
apple | avocado | cereal | brioche | pasta | chips |
beef | berries | sausage | toast | sandwich | hot dogs |
cheese |
My range is AD62:CI89 and this is fixed, so there's only ever going to be 28 rows, and there will be a maximum of 8 articles in the end for each column. There's no relation between each column, so loosing the empty cells won't bother me. The important thing is to keep the columns separate.
I'd assumed I could used filters to remove empty cells, but I can only work out how to filter on one column, and that hides the information from the other cells too!
HELP!