I have a list of redundant rows like this
See my Google sheet
Target FRBBED05517 Job state EXECUTION_ORDERED Target FRBBED05523 Job state EXECUTION_ERROR Target FRBBED05547 Job state EXECUTION_ERROR Target FRBBED05584 Job state EXECUTION_ERROR
And I want to transform them in columns like this
See my Google sheet
FRBBED05517 EXECUTION_ORDERED FRBBED05523 EXECUTION_ERROR FRBBED05547 EXECUTION_ERROR FRBBED05584 EXECUTION_ERROR FRBBED05620 EXECUTION_ERROR
Is it a simple way to do it ?
I have here a example to test Google sheet