Forum Discussion
Solved
List of Service Providers
I have a spreadsheet where I have columns for service provider name, address, phone number. The next 12 columns are the name of a service they provide. They made provide more than one so in the row ...
=FILTER($A$2:$A$17&" "&$B$2:$B$17&" "&$C$2:$C$17,D2:D17="x")You can use FILTER function. The formula is entered in cell D19 and copied across range D19:O19.
=FILTER($A$2:$A$17&" "&$B$2:$B$17&" "&$C$2:$C$17,D2:D17="x")You can use FILTER function. The formula is entered in cell D19 and copied across range D19:O19.
Thank you so much for suggesting the filter.
Tricia
