# Build a cumulative list of roles (headings) from a table of outlets and required numbers

1. ## Build a cumulative list of roles (headings) from a table of outlets and required numbers

Outlet Supervisor Host Bar Floor Runner
Level 1 2 1 1 4 1
Mezzanine 1 1 1 5 1
Level 2 2 1 2 8 3

Indicative list
Supervisor
Supervisor
Host
Bar
Bar
Floor
Floor
Floor
Floor
Runner
Supervisor
Host
Bar
Floor
Floor
Floor

2. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Welcome to the forum.

What's the logic?

3. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Sorry the post wasn't clear. The table should be as follows:

Attachment 651464

With the result being
Indicative list
Supervisor
Supervisor
Host
Bar
Floor
Floor
Floor
Supervisor
Host
Bar
Floor
Floor
Floor
Floor

4. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Still can’t fathom it - sorry.

Try explaining in words what you are trying to achieve.

5. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

I'm trying to work out the formula to build a column of roles from the numbers required as per the table, so that the column builds down from the numbers required in each row and then builds the next row and so on, so for example if i need 1 supervisor and 2 bar in one venue then 2 supervisor and 3 bar in another it will build them like below:

Supervisor
Bar
Bar
Supervisor
Supervisor
Bar
Bar
Bar

Does that make sense?

6. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

J4
``Please Login or Register  to view this content.``
Regards.

7. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Hi there,
No that didn't work, but I am not sure what the content is meant to be in L3 or is that just a blank cell?

8. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Sorry for my mistake >_<
Plese try again.

``Please Login or Register  to view this content.``
Regards.

9. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Formula:
`Please Login or Register  to view this content.`

Or Power Query

Open Power Query/Get and Transform. Click on New Query.
Open blank query in the editor, launch Advanced Editor and paste in the following code.

``Please Login or Register  to view this content.``

10. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

THANK YOU! That is brilliant. Worked perfectly.

11. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Can you then reverse it to build the other list, such as.

Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Level 1
Mezzanine
Mezzanine
Mezzanine
Mezzanine

Or can I get away with a shorter formula for that?

12. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

N4
Formula:
`Please Login or Register  to view this content.`

O4
Formula:
`Please Login or Register  to view this content.`

13. ## Re: Build a cumulative list of roles (headings) from a table of outlets and required numbe

Hi there,
Works perfectly. Thank you so much for all your help.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1