Skip to main content

Hi All,

It seemed a bit easy but i am stuck with it now. Can someone please help?

My input is somewhat like this:

 

and my desired output is like this:

The 6 values (Acquisition date, Analysis Date, System, Method, Sample ID and Data filename) are repeating three times in first column and have different values. I have attached the excel file for your reference.

This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.


This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

Thanks a lot @takashi. It worked fine.


This workflow might help you. The point is to use the AttributeCreator to create new attribute whose name is value of attribute A.

@takashi Thanks for providing the solution earlier. How do we carry out the same process if we have multiple columns in hand and the rows in first column ?


Reply