Good afternoon. I have a stacked dataset that repeats 5 or 6 rows of information. I followed a youtube video on how to pivot the columns using an index column and filling up with the data then filtering out the "null" rows. The problem I have is that some of the records have a currency amount. Not all. So when I filled up, the dollar amount didn't stop at the next record. Is there a way in Power Query to replace the values in the cells that shouldn't have a dollar amount. When I close and load the query, I filtered out the Currency Item Type and removed the dollar amount from the effected cells. Every time I refresh my dataset though, the dollar amounts reappear because they appear in the query.
I have 3 Columns: Item Type, Description, $ Amount.
Any help would be appreciated.
I have 3 Columns: Item Type, Description, $ Amount.
Any help would be appreciated.