Forum Discussion
Helper VUnpivot Cashflow Data for 140 month project
I suggest you highlight the first four columns in Query Editor after import, right-click, then choose Unpivot Other Columns
You shouldn't need to change your dashes, as your second screenshot shows them being imported as zeroes - the dash seems like just a presentation style in Excel.
Note that your Excel column headers aren't being automatically imported from your Excel spreadsheet - maybe the data isn't formatted as an Excel table? Unless you format as a table, you'll need to Use First Row as Headers, before you Unpivot per above.
Click the filter dropdown on your Value column, then Number Filters>, then Does not Equal..., then 0
Helper VAnonymous
Thanks Steve, i just went with converting the Excel data by creating the headers...so the dates became a header. That was the easiest way I found.
Then when I used the Unpivot command the Attribute field could be renamed to the Date field which worked fine.
The $$ values now show in a seperate column as well as the date.
Just out of interest is there any easy way to remove the zero values from the table?
Thanks Again.
Click the filter dropdown on your Value column, then Number Filters>, then Does not Equal..., then 0