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

[madhurinani]

Hi,

I have the data in the following format.

A	B
abc
	xyz
two	one
	three
four	five

How can i get the output in the below format?

A	B
abc	xyz
two	one
four	three
	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

[IraWatt]

Hey @madhurinani,

Very interesting problem. Here is one way to do this:

This solution uses the transpose, cross tab and multi row formula tools which can be hard to understand to new users. I would recommend checking out the community Getting-Started-Learning-Path for some context on how they work: https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117#done  https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Ladarthure · Accepted solution]

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