anandbohra
11-20-2007, 11:21 PM
Hi All
every time i stuck in For loop only pl help
I have Large data of 6000 Rows by 23 Columns
which i want to convert into 138000 rows by transposing one below other with condition if row exceed 60000 then jump to next sheet
eg. Sheet 1 contains my data matrix 6000 rows * 23 columns
now copy row 1 paste it as transpose in Sheet 2 (now it has 23 rows)
then again go to sheet 1 copy row 2 again paste it as transpose in Sheet2 at the end ( now it has 46 rows)
repeat this proceedure till total rows reaches 60000 if it exceeds 60000 then add new sheet & continue the proceedure till last row in Sheet 1 (i.e. till row 6000)
PL help
every time i stuck in For loop only pl help
I have Large data of 6000 Rows by 23 Columns
which i want to convert into 138000 rows by transposing one below other with condition if row exceed 60000 then jump to next sheet
eg. Sheet 1 contains my data matrix 6000 rows * 23 columns
now copy row 1 paste it as transpose in Sheet 2 (now it has 23 rows)
then again go to sheet 1 copy row 2 again paste it as transpose in Sheet2 at the end ( now it has 46 rows)
repeat this proceedure till total rows reaches 60000 if it exceeds 60000 then add new sheet & continue the proceedure till last row in Sheet 1 (i.e. till row 6000)
PL help