I need a way to count the number of states each project participates in. For example, for Project A I should be able to says West Va and Va. Smartsheet will not allow me to count the state column. So I would then like to be able to separate each project by row based on the state column. I found VBA code to use in Excel to create rows under the original row, but I would prefer not to export from Smartsheet to Excel to go back into Smartsheet to pull in for Power BI.
In total there will be two sheets. The second sheet will pull in from the first sheet.