Hi, would like to seek for guidance on how to transpose from input to desired output from the attached workflow. Please help. Thank you!
to this ->
Hello Karenlmk.
I probably didn't use the functions you wanted, but here is the corect aswer.
English isn't my first language,
please ignore my grammar errors.
@karenlmk One way of doing this with the batch macro
@karenlmk I rarely use this tool but maybe it wil lwork in your case.
didn't use transpose but got what you were look for
Is this data very similar to your actual data? Can you identify the values that go in the different columns by keying off a string that starts with "ID_" or "NUM"?
If not, how would you manually identify which original Name value goes in the new columns for Name or Name2?
Chris
Thank you all for the solutions! All works!! Thanks again!!
