Splitting Columns based on data in another.

joconnor224

Hi everyone, I'm new to alteryx and have encountered a problem with the dataset I am working on. If anyone can help me that would be great thanks! 

	Vehicle/Colour	Number
	Van	10
0	Blue	6
0	White	4
	Car	20
0	Red	15
0	Silver	2
0	Black	3
	Truck	4
0	White	4
	Boat	2
0	Orange	1
0	Pink	1

I am trying to split the Vehicle/Colour column into its correct format. The colours are marked by a 0 in the first column where as the vehicles are not. I then also need the first row to be deleted (where the vehicle type was first listed. My end result would be as follows:

Vehicle	Colour	Number
Van	Blue	6
Van	White	4
Car	Red	15
Car	Silver	2
Car	Black	3
Truck	White	4
Boat	Orange	1
Boat	Pink	1

Thanks everyone. 

RolandSchubert

Hi @joconnor224 ,

you can use the Multi-Row Formula tool. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

Splitting Columns.yxmd