Dear All,


I want to fetch data from horizontal to vertical .
Data format is c6:j6 total eight values c7:j7 upto c21 to j21 total 128
values.
This 128 values which was placed horizontal i want to pull it into
vertical col.
i.e Range C6:J6 into D1:D8 and C7:J7 into D9:D16 and so on till range
C21to J21 into D... :D ... vertical.
Please assist either macro or Function.

Rgds,
aligahk06

Does this do it for you:

Highlight what you want changed

Copy

Move your Cursor to where you want the data

Go to Paste Special, then select Transpose