Hi Skye, Stephen is right in terms of the Excel steps being "involved", but I think if you set up the framework properly, the ongoing update/refresh process wouldn't be too terrible. He's correct that you'd start out with "text to columns". Your goal would be column headings to this effect: Form, State1, State2, State3, etc. Once you've got the data in the columns, I'd then highlight it all and convert it to a table (Insert/Table). This isn't completely necessary but would set you up with a better platform for regular updates. The rest depends a bit on what version of Excel you have. If you have 2013, you can load the PowerQuery add-in; I believe 2016 has the functionality built in already. (I'm not on 2016, so I'll explain with 2013 that has PowerQuery loaded…not every step, but enough to give you some direction.) Click anywhere in your table, and under the PowerQuery menu, select "From Table". This will pull your table headers and data into the PowerQuery builder. In the PowerQuery window, highlight your "State" column headers (not the "Form" one), go to "Transform", and select "Unpivot Columns". Next, right-click on the column header that now contains State1, State2, State3, etc. (by default, it's probably called "Attribute"), and click "Delete". At this point, the data is in roughly the format you need. Make note of the name shown in the pane to the right (under Query Settings). Under the "Home" tab, select "Close & Load" then "Close & Load To"; select "Only Create Connection" and do not check "Load to Data Model", then click "Load". To get that revised data back into Excel, go to a new sheet, click in a cell. From under the "Data" tab, select "Existing Connections". "Connections in this workbook" should show you the name of the table you created under Power Query. Click "Open" and "OK", which should place the data in your worksheet. At this point, you can either just use the table to filter by state (as Stephen noted), or you could get fancy and create a pivot table, where you would throw first "State" and then "Form" into the rows area (at that point, I'd probably play with the options a bit to make the format more tabular). Whew! To update the data in the future, you'd pull your report from Workfront again, throw it in any Excel sheet and do the "text to columns" thing again. Then, just paste the resulting data (NOT the headers! Don't overwrite those!) into the table we initially started with. Then go to the final table, click anywhere in it, and select Data/Refresh/Refresh All. All those steps you manually built in PowerQuery will rerun, and tada! The table will show the updated data. While it's a bit daunting the first time around, if you like Excel, it's really sort of fun. :-) I have a number of things I use PowerQuery on to update Excel-based Workfront reports on a weekly basis. Hopefully my description wasn't too cryptic and will get you going in the proper direction, if you choose that route. Kathy
