Hey @Chirag_Gandhi07!
I would recommend first using the Transpose tool, using Email as a key field. Next, Filter out the empty Values. Lastly, use a Cross Tab tool, grouping by the Email field. This should do the trick!
Here is the sample workflow for your case. Hope this is helpful.
@Chirag_Gandhi07 One way to do this would be to take only the first row from your original data then Union it to your output from the Cross Tab tool. In the Union tool, ensure that you choose to set a Specific Output Order and make your one sample row the first row. Finally, just use another Sample tool to get rid of that first extra row. The reason this works is because the Union tool will preserve the field order for the data you set to be the first in the output order. See the attached workflow. Hope this helps!
Here is another sample workflow. Hope this is helpful.
I think there is risk in the assumption that you will have only version of an email populated for any given column, but regardless, the solution is quite simple. Just use the Summary Tool, grouping by the Email and concatenating the columns. This solution means you don't lose any data that mayhaps be on other versions of a given email. It retains the column order, and it is a single tool instead of a bunch of them.
