Small Macro
I need help with a small program to arrange a data file: This is the data file: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 I need the data to be arrange as shown below: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 Thanks -- tbob ----------------------------------------------------------------------- tbobo's Profile: http://www.excelforum.com/member.php...fo&userid=3153 View this thread: http://www.excelforum.com/showthread.php?threadid=52576 |
Small Macro
Hi tbobo,
You dont need a macro ... Just Edit Copy Edit PasteSpecial Transpose HTH Carim |
Small Macro
This can be done with a formula.
See example: http://cjoint.com/?dxsKNTriB0 HTH -- AP "tbobo" a écrit dans le message de ... I need help with a small program to arrange a data file: This is the data file: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 I need the data to be arrange as shown below: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 Thanks! -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=525765 |
Small Macro
Macro not needed:
If you data is in column A, then in B1 enter: =INDIRECT("A" & ROW()*5-6+COLUMN()) Then copy B1 to C1 thru F1. Then copy B1 thru F1 down as far as you need. -- Gary's Student "tbobo" wrote: I need help with a small program to arrange a data file: This is the data file: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 I need the data to be arrange as shown below: data A B C D data 1 2 3 4 data D E F G data 5 6 7 8 Thanks! -- tbobo ------------------------------------------------------------------------ tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530 View this thread: http://www.excelforum.com/showthread...hreadid=525765 |
All times are GMT +1. The time now is 10:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com