Hi,

I have set of data from B1:F1 rows and like this I have nearly 600 lines of
data, I need to copy all this data and paste into column A with the transpose
option. I This will be difficult if I want to repeat for 600 lines.

Is there anyway we can do with the formula.

Regards,
Igneshwara Reddy.