I am not sure if I am using the correct terms so bear with me
I have 10 different excel files that list the following fields (I can combine the files)
Department, Issue, User Corrective Action, Steps and Root cause I am trying to merge them into a select box on SharePoint using Excel as the data source or a Excel form this is for our front line helpdesk to do some initional trouble shooting
the Logic should be like this.
i.e.
User Selects Department BI in the next Box/Field/Dropdown list only Issues that could be related to BI are shown user selects one of those issues and on the next box/field/dropdown list only fixes for that select issue we are calling it a triage list.
To make this short and sweet HELP