How to remove empty rows and move the data to the top?

Question

Hi,

I have the data in the following format.

ABabc  xyztwoone three  fourfive

How can i get the output in the below format?

ABabcxyztwoonefourthree five

I tried using the Summarize function and get all the records as a group but unable to remove the empty rows and move it on the top.

ANy help would be appreciated

Ladarthure · Accepted Answer

@madhurinani a way to do this is to use transpose and cross tab I made a sample workflow with a dynamic method