How to arrange multiple columns in single or two columns via macro

[Nitesh Mathur]

Hi,

Im using MS Excel 2007 and trying to find out a macro for arranging multiple columns in single or two columns.

I have two sheets
1. Sheet "Data" - Data table is available with name, month and percentage
2. Sheet "Result" - Required to arrange name , month and percentage as mentioned in "Result" sheet.

Sample Excel file attached for your reference.

Thanks

Nitesh

 

[BBD]

Hi Nitesh,

Attached is the file with the macro. You will have to run it after selecting the range which has the percentage values. So in this case, it would be B2:E9. Select this range. Press Alt+F8 and run the macro test.

Thanks,
BD

 

[Nitesh Mathur]

Hi Nitesh,

Attached is the file with the macro. You will have to run it after selecting the range which has the percentage values. So in this case, it would be B2:E9. Select this range. Press Alt+F8 and run the macro test.

Thanks,
BD

Thanks BD .... its working.