I have two sheets in Excel with the following content:
Sheet1
Sheet2Please Login or Register to view this content.
Now, I want to merge these two sheets into Sheet3 as the following:Please Login or Register to view this content.
Sheet3
These numbers are just examples here. The real data is too big, with nearly 2000 rows. So I cannot copy and paste them manually. Besides, the data are dynamically changed from the web, so I need some formula to re-arrange them automatically every time.Please Login or Register to view this content.
Which functions or formulas can I use to re-arrange these data as above ?
Bookmarks