Duplicating rows and adding information

jessicawhite03

Hello,

Please see the attached screenshot of my workflow and the mocked results. I’m trying to transform multiple columns into two rows: Accident Year and Amount. The Accident Year would come from the column headers, and the Amount would be the corresponding values in each column.

What is the best way to duplicate the rows and create these two new fields?

Thanks in advance!

Jessica

Results and Change.png

Current Workflow.png

OTrieger

@jessicawhite03 
Hi Jessica,
Check Transpose and Cross Tab tools. Get familiar with them as they are very useful tools.