I am trying sort data by headers in a situation where I have a lot of
variables but some are missing. I have all my data like this:

City A Value for variable 1
City B Value for variable 1
City C Value for variable 1

City A Value for variable 2
City B Value for variable 2
City C Value for variable 2

My problem is, that sometimes I do not have the data for some variable for a
given city. For these cities, I do not have the city name either. To do
plots, I put the data into the same worksheet in adjacent columns.

What happens is this:
City A Value for variable 1 City A Value for variable 2
City B Value for variable 1 City C Value for variable 2
City C Value for variable 1 City D Value for variable 2
City D Value for variable 1 City E Value for variable 2

This is what I would need:
City A Value for variable 1 City A Value for variable 2
City B Value for variable 1
City C Value for variable 1 City C Value for variable 2
City D Value for variable 1 City D Value for variable 2

I would like to do this for all my variables for an end result like this:
City A Value for variable 1 Value for variable 2 Value for variable 3
City B Value for variable 1 N/A Value for
variable 3
City C Value for variable 1 Value for variable 2 N/A
City D Value for variable 1 Value for variable 2 Value for variable 3
Etc.

Any advice will be greatly appreciated.