Transpose data

[sunnybrook]

Hi, apologies if this has been answered before...

Let's say that I have directions to get somewhere in the form of a column for map page numbers and each row is the page number and the square references. How can I reverse the route?

e.g. change....

29 E1 F1 G1
30 B3 C3 C4 D4
31 E4 F4 G4 H4 H5

to

31 H5 H4 G4 F4 E4
30 D4 C4 C3 B3
29 G1 F1 E1

bearing in mind that page numbers may not necessarily be in order.

[VBA Noob]

Hi,

Here's my attempt with some VBA Code

VBA Noob

[sunnybrook]

Thanks for that

Of course, it would look nicer if the cells could be left justified, as prior to transposing them

Thanks again for the swift response

[VBA Noob]

Hi,

This is a formula version

VBA Noob

[Jon]

Hi,

I'm trying to do something similar, but want it to work over a highlighted range if possible.

This range will vary (i.e. not always in column E:F for e.g.); but does anyone have a macro that will vertically invert each column that I've highlighted (so I can tie it to a button)?