Building list from drop-down selections

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

unsolved

Post Body

Hi all,

I'm building a character sheet for a game. I have several drop-down lists for purchasing starting equipment.

I have three separate drop-down lists: Melee weapons, handguns, and long guns. Each of these lists appears a few times, for multiple selections in each category if desired.

The player chooses two melee weapons and a long gun.

Is it possible, on a later "summary" tab, to have the selected melee weapons and handgun appear in a single column, without any spaces from "unused" dropdowns?

EDIT: More explanation in comment reply below.

Any guidance will be appreciated, thanks.

Author

Account Strength

100%

Account Age

4 years

Verified Email

Yes

Verified Flair

Total Karma

15,897

Link Karma

2,366

Comment Karma

13,411

Profile updated: 4 days ago

Posts updated: 1 year ago

ScreamBeanBabyQueen

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 1 year ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...