Apr 09, 2017 Question: Q: how do i get word and excel on my mac. Hi, I have recently bought a Mac book pro. Till now have been using a acer laptop. Can any one help with the following. I want to transfer all my data( mostly word, excel and photos) to my Mac.
I have a folder include 10 excel files. Each of the excel file contain 5 sheets. I would like to concatenate every 1st row in 1st sheet of each excel file into new sheet1 in new excel file named 'final' concatenate every 2nd row in 1st sheet of each excel file into new sheet1 in new excel file named 'final' concatenate every 3rd row in 1st sheet of each excel file into new sheet1 in new excel file named 'final'. Then concatenate every 1st row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final' concatenate every 2nd row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final' concatenate every 3rd row in 2nd sheet of each excel file into new sheet2 in new excel file named 'final'. Repeatedly.do for all 5 sheets. Example: excel file 1, sheet1 30 4 1.6 1.2 1.2 1.0 35 16 0.9 0.9 1.5 1.0 40 62 0.9 0.9 1.6 1.2 45 3 0.9 0.9 0.9 0.9 50 1 1.5 1.5 0.8 0.8 excel file 2, sheet1 10 1 0.8 0.9 0.9 0.9 15 31 0.9 0.9 1.2 1.6 20 2 0.9 0.9 0.9 0.9 25 3 0.9 0.9 0.9 0.9 30 18 0.9 0.9 0.9 0.9 excel file 3, sheet1 to excel file 10, sheet 1 etc.
The result i would like to get final.xls, sheet1 30 4 1.6 1.2 1.2 1.0%1st row of sheet1 in excel file 1 10 1 0.8 0.9 0.9 0.9%1st row of sheet1 in excel file 2.%repeated 1st row of sheet1 in excel file 3 to 10 35 16 0.9 0.9 1.5 1.0%2nd row of sheet1 in excel file 1 15 31 0.9 0.9 1.2 1.6%2nd row of sheet1 in excel file 2.%repeated 2nd row of sheet1 in excel file 3 to 10 final.xls, sheet2%similar to sheet1 just the data read from sheet2. Does anyone can help me?