Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
List.Transform
Applies a function to each element in a list in Power Query.
Sum Without First And Last
Challenge No. 688: Sum all the numbers given in column A except the first and last numbers in every cell.
Solved using: R.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
Draw Alphabet Z Pattern
Challenge No. 668: Create alphabetic Z for N values as shown.
Solved using: Python.
Largest Alternating Digit Substring
Challenge No. 657: Find the largest substring number which has alternating odd/even or even/odd digits.
Solved using: R.
Detect Sequence Direction
Challenge No. 655: Find whether a sequence is increasing (I), decreasing (D) or neither of these (N).
Solved using: Python.
Last Sundays Of Year
Challenge No. 653: List the last Sundays of the all 12 months of year given in cell A2.
Solved using: Python in Excel.
Generate Sequential Tickets
Challenge No. 652: Generate the ticket numbers as given.
Solved using: Python.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.