Splitting Data into two rows

[Toby_VAA]

I'm trying to get some data in a format to import to tableau for some hub spoke type diagrams.

What i have so far is data formatted like the below 

RecordID	Cost	Origin	Destination	Origin Lat	Origin Long	Dest Lat	Dest Long
1	300	LGW	ANU	51.14810181	-0.190277994	17.1367	-61.792702

And I need to split each row into two records and create a path id so it looks like the below - so each row would be split into a path 1 and path 2 row with origin lat and long associated with path1 

RecordID	Cost	Origin	Destination	Lat	Long	Path
1	300	LGW	ANU	51.14810181	-0.190277994	1
1	300	LGW	ANU	17.1367	-61.792702	2

Any help would be greatly appreciated

Thanks

Toby

[mborriero · Accepted solution]

Hi @Toby_VAA, please find my solution attached.

I split the file in two, one contains just origin information and the other one contains just destination information, renaming the fields Lat and Long.

I have add a formula for the path, the file with origin information has path=1, the destination one has path=2

Then I union the two file together.

[Toby_VAA]

Thanks, worked perfectly!

[Joe_Mako]

Another option is to use the Arrange tool: