Drop-down lists can facilitate accurate data entry in spreadsheets by restricting input to predefined choices specified in the drop-down. To create a drop-down list, first enter all possible options you would like included in the validation list. Then, visit the Data tab, click Data Validation,...
This solution would make your workflow dynamic enough to handle any amount of input rows that may come in. If your input/output look like this, then this solution should work for you: InputDesired Output First create a RecordID then CrossTab your data using the RecordID as the headers and...