This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to recreate an import file I used to create using the pivot function in Excel. Basically, I need it to look like this:
Here is the sample data I am working with which includes a tab with what the file should look like. I am close but basically need help adding the row that identifies the tax type with a another column underneath that summarizes the tax amount and nontaxable amoun