How to read form values in excel

Hi All,
  I am new to this tool; I need to capture the form values from the first worksheet and data set in other worksheets.
 it look likes below:
 

 So, how to efficiently capture the cover data into a single record? Now what I can do is to capture each field one-by-one and store it in variables, and then read those fields to the out of a single record. any better approach?
 

thank you.

Perfect timing for asking this kind of question.

It is very easy to process structured Excel data but when you have data all over the place it may become overly complicated.

In the latest version, we have introduced a block transformation (It was released two days ago)

Block transformation was specially designed for cases like yours.The way it works is very simple:

• User marks data blocks within the Excel file
• Every block can be then transformed individually eg: reformated, sorted, filtered, or rotated 
• Block can be also combined into one
• The results are then written into one or multiple Excel files

 

   

 

I have attached a working example for you. Please bear in mind that it is a new feature and it may have bugs.
(This morning we found two and fixed them)

Please let us know if you have any suggestions or face any issues.

We will implement all of them