Hello All,
I am a basic user of Excel. I do not know Macros or VBA. I have a task which I hope you will be able to help. The task is given below.
I have an Excel datasheet with 4 columns and 4485 rows.
I want to rearrange this data to get a 69 X 260 matrix i.e. 69 rows & 260 columns.
That means, from the present datasheet, each block of 65 rows should be arranged in a single row in the following way.
Please see the attached sample workbook
In the table below, the red chracters are actual data. The top row & the left-row shows the columns & rows respectively in Excel.
Present data:
A B C D
1 101 102 103 104
2 105 106 107 108. . . . .
. . . . .
65 357 358 359 360
66 361 362 363 364
Required data:
A B C D . . IY IZ
1 101 102 103 104 . . 359 360
2 361 362 363 364 . . 619 620
. . . . . . . . .
. . . . . . . . .
69 6901 6902 6903 6904 . . 7159 7160
Please see the attached sample workbook
I want your expert help in resolving my problem.
Thanks a lot.
Bookmarks