karlos
08-13-2008, 04:24 AM
Been modifing several dozen excel sheets this week, latest problem,
Column A down to A 5000 or so is populated with Formula.
I need to transpose column A data every 25 may be more but this can be changed I assume by manually changing a macro.
So move or copy all data in Column A in blocks of 25 to rows
so row 1 would have 25 (column data A1 to A25)
row 2 would have the next 25 (column data A26 to A50)
row 3 woulde have the next 25 Column data A51 to 75)
I could transpose manually but the task looks daunting,
Can anyone assist please.
:help
Column A down to A 5000 or so is populated with Formula.
I need to transpose column A data every 25 may be more but this can be changed I assume by manually changing a macro.
So move or copy all data in Column A in blocks of 25 to rows
so row 1 would have 25 (column data A1 to A25)
row 2 would have the next 25 (column data A26 to A50)
row 3 woulde have the next 25 Column data A51 to 75)
I could transpose manually but the task looks daunting,
Can anyone assist please.
:help