Skip to content

ListCombine Workout Routine

Let's get this workout started!
What is it?
List - Creates a list
ListCombine - Creates one unified list
When to use it?
When you need to change the data type to be a list
When you need to join lists together
When you have a list of lists

Exercise 1

You want to know how many items of
@Outerwear
were sold.
Your answer:
Reveal Answer
15

Exercise 2

You want to know all of the unique items that were sold this month.
Your answer:
Reveal answer
Jumpsuits & Rompers Outerwear Shoes Headbands Swimwear Dresses

Exercise 3

You want to create a select list that has both the and as options.
Your answer:
Date
Items sold
5/3/2021
4/26/2021
4/28/2021
There are no rows in this table

Reveal answer

Date
Items sold
5/3/2021
4/26/2021
4/28/2021
There are no rows in this table

Exercise 4

You want to generate sale prices for every bundle and product you have. You’re going to offer 20% off.
Your answer:
Reveal answer
$36.00
$36.80
$16.80
$4.00
$0.80
$8.00
$16.00
$12.00
$4.00
$8.00

Exercise 5

You have a table where people can choose which shift they want to pick. You have a morning and an evening shift, and want the column to automatically have both shift options listed.
Your answer:
Shifts
Day
Time
Person
Mon
MM
Maria Marquis
Tues
MM
Maria Marquis
Weds
MM
Maria Marquis
Thurs
MM
Maria Marquis
Fri
MM
Maria Marquis
There are no rows in this table
Reveal Answer

Shifts Answer
Day
Time
Person
Mon
Melanie Heyside
Tues
MM
Maria Marquis
Weds
MM
Maria Marquis
Thurs
MM
Maria Marquis
Fri
MM
Maria Marquis
There are no rows in this table



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.