Excel - transpose data and fill blank header

Question

Hello -

I am struggling with creating a workflow - I've attached the "TEST" input excel file. I am trying to accomplish an output file that would:

* Row 4 includes header name, followed by blank columns - I want to populate the blank cells with the header name included to the left. Example - Cells F4-R4 would show "Grand Total", Cells U4-AG4 would show "C001000" 
* Transpose data to include the following columns: * What is currently in Column A "Gross Temporary Differences Assets (Liabilities)
* What is currently in Col. C
* Values - converted to a number format

* Remove all values that equal 0

Thank you

TEST.xlsx

bradaba33 · Answer

@acarter881

Thank you - to clarify, I've attached a revised TEST excel file. I've added a "Wanted Output" tab to show what I'm trying to accomplish.

The piece I am struggling with, how can I transpose the data and have the values that are currently in Rows 10 and 11 be properly transposed as well.

Appreciate the help.

TEST.xlsx

acarter881 · Answer

Hello, @bradaba33.

Please see the attached workflow.

Your data set is fairly large. I'd run the attached workflow on a data set with ~200 columns as a test.

I took a first pass at creating what you're looking to achieve. I would need clarification on the exact output that's required.

the test.yxmd