I would appreciate help on the above-mentioned topic.
I am unfamiliar with Visual Basic for Excel, so will need step-by-step guidance (if solution is via Visual Basic).
For example :-
Row 1, Sheet A:
A1 B1 C1 D1 E1 F1 G1 H1 I1
To be re-arranged into Sheet B :
Row 1 : A1, B1, C1
Row 2 : D1, E1, F1
Row 3 : G1, H1, I1
The Sheet A (database sheet) has a lot of rows (example 3,000 rows), hence the Sheet B is estimated to have 9,000 rows (i.e. 3 x 3,000).
Thanking you in anticipation of your speedy response.
Best Answer
The solution to this lies in using the excel Row/Column and Indirect sheet function.
if the original data is in sheet1, then in sheet 2 paste the following formula:
and then drag the formula across and down