Hi gurus,
Greetings first.
New to Excel, need a baby walk through it.
I want to transpose data from sheet1 to sheet2.Data i have is in vertical form, need it be in horizontal form.A simple example:-
Sheet 1:- Starting from a2 and ending at d9 . A2 starts from A2=01, and ends atD9 =40(missing data in between represented by empty cells. Want it in a row (Sheet2. A2). 01,02, 05, 07, 40.
A10 is a blank row,or we can a put a special sign to tell macro tat is end of first record.Total 2k records to be transposed in sheet2
Want macro to do it till all data is transposed.
Thanks
Bookmarks