2. Open the worksheet Z of "Report", and first create a header "Print as worksheet", with d carriage return = if (mod (row (), 3) = 0, "A2 cell if (mod (row (), 3) = 1, report! A $2 index (report card! $A:$J, INT((ROW()+4)/3), COLUMN ()), and then click enter.
3 Use fill handle to extend A2 to J2. Now, you can see the following effect in line 2:
Name, Chinese, Mathematics, English, Physical Chemistry, Total Score, Average Score, Trinity Judgment
4 Select the second line, use fill handle to drop down a line, and you will see a complete report card:
Name, Chinese, Mathematics, English, Physical Chemistry, Total Score, Average Score, Trinity Judgment
Li Rui 50 60 40 50 60 40 300 60 1 ×
5 Select lines 4 and 5, and always use fill handle to pull down, and you can complete this report.
After the production is completed, you can upload the Excel form to Easy Tea Powder, scan the published exclusive query QR code, and establish the query system in three minutes.