Invert selected columns

**worldwebber** · 10-29-2014, 01:22 PM

Hi.

I have several hundred documents looking like this:

Start 1 A B C D E F G
1959 P 45 60 85 120 180 275 400
1959 R 45 60 85 120 180 275 400
1960 S 45 60 85 110 150 210 350
1960 T 45 60 85 120 180 300 475

Is there an easy way to "invert" how the last 7 columns are shown so that the sheet starts from left with G then F, E, D, C, B, A without having to copy/paste each coloumn seperately into a new sheet?
In other words, is there an easy way to get to this?:

Start 1 G F E D C B A
1959 P 400 275 180 120 85 60 45
1959 R 400 275 180 120 85 60 45
1960 S 400 275 180 120 85 60 45
1960 T 350 210 150 110 85 60 45

Thankful if somebody have a "quickfix" on this for a excel newbee like me :-)

**newdoverman** · 10-29-2014, 04:06 PM

With A to G at the top of the columns as headers, select the data A-G from row 1 to the end of the data. Click on the Data Tab, Sort Button, Options Left to right, Sort on Row 1, Z to A click ok

BEFORE:

	A	B	C	D	E	F	G	H	I
1	Start	1	A	B	C	D	E	F	G
2	1959	P	45	60	85	120	180	275	400
3	1959	R	45	60	85	120	180	275	400
4	1960	S	45	60	85	110	150	210	350
5	1960	T	45	60	85	120	180	300	475

AFTER:

	A	B	C	D	E	F	G	H	I
1	Start	1	G	F	E	D	C	B	A
2	1959	P	400	275	180	120	85	60	45
3	1959	R	400	275	180	120	85	60	45
4	1960	S	350	210	150	110	85	60	45
5	1960	T	475	300	180	120	85	60	45

**worldwebber** · 10-30-2014, 02:57 PM

Thank you! Saved me a lot of work :-)

**newdoverman** · 10-30-2014, 05:56 PM

It's a simple solution. I'm glad that it works for you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.