Excel

 https://support.microsoft.com/en-au/office/import-data-from-the-web-b13eed81-33fe-410d-9247-1747269c28e4

https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b#:~:text=If%20you%20want%2C%20you%20can,%3AB5%20equal%20%22John.%22

https://www.reddit.com/r/excel/comments/eji3gd/repeating_two_alternating_formulas_down_a_column/

https://www.mrexcel.com/board/threads/formula-to-find-the-value-of-the-closest-non-blank-cell-to-the-left.1011122/

https://www.quora.com/How-do-I-replace-value-with-0-in-Excel

To stop an operation: click 'escape'

https://excelchamps.com/formulas/remove-parentheses/#:~:text=First%2C%20select%20the%20range%20of,and%20then%20click%20Replace%20All. 
https://techcommunity.microsoft.com/discussions/excelgeneral/combine-data-from-2-columns-into-1-column/242822 = B2& " " & C2  - quotation  marks for space

https://answers.microsoft.com/en-us/msoffice/forum/all/remove-spaces-before-and-after-the-word-in-cell/ae11ab52-0a12-4ae0-9fca-11b396c2d8af
=TRIM(SUBSTITUTE(A1:A22,CHAR(160),"")) https://www.ablebits.com/office-addins-blog/capitalize-first-letter-excel/ Capitalize first letter in cell and make others lower-case =REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1))) To make first letter of each word upper case: =PROPER(A2) 4 https://stackoverflow.com/questions/50155395/split-one-column-into-two-columns-based-on-the-row-is-odd-or-even

=INDEX(A:A,2*ROW()-1) =INDEX(A:A,2*ROW()) https://stackoverflow.com/questions/211062/copy-every-nth-line-from-one-sheet-to-another

=OFFSET(Sheet1!$A$1,(ROW()-1)*7,0)

How to repeat each row four times: 

=INDEX(A:A,CEILING(ROWS(C$1:C1)/4,1))

https://stackoverflow.com/questions/45637400/excel-merge-two-columns-into-one-column-with-alternating-values
=TOCOL(A1:B3) https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-remove-preceding-zeros-from-a-number-like/47332443-5937-4552-af47-16dbc3d03de3 =VALUE(A1)