Transpose rows under 1 field and concatenate with values from different fields

[JoRao]

Hello All - This is my first post here. I am trying to convert the rows under one field to different  field names and concatenate each field name that was derived from rows with other field names. I have attached a sample worksheet showing what I want my end product to  look like.

Thanks in advance for your help!

[JordanB · Accepted solution]

Hi @JoRao

This article will help you with the multiple .xls sheets.

You can then use the interface Designer and set the output option as:

This will account for the selected fields.

Best,

Jordan 

[JoRao]

Worked perfectly @JordanB. Greatly appreciate all your help with this! THANK YOU!!!

Best,

Jo