Excel - transpose data and fill blank header

[bradaba33]

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: 

1. 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" 
2. Transpose data to include the following columns: 
   1. What is currently in Column A "Gross Temporary Differences Assets (Liabilities)
   2. What is currently in Col. C
   3. Values - converted to a number format
3. Remove all values that equal 0

Thank you 

[acarter881]

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.

[bradaba33]

@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.