Solved

Accumulating and transposing rows

  • 16 August 2019
  • 3 replies
  • 2 views

Badge

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.

icon

Best answer by takashi 16 August 2019, 16:48

View original

3 replies

Userlevel 2
Badge +17

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

Badge

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.

Badge

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