Split two columns into four based on value of first column

[atjhsieh]

Hi, I have a table that includes the following two columns: 

Count	Value
Device Activity Count (7 Day)	0
Device Activity Count (14 Day)	3
Device Activity Count (30 Day)	9
Device Activity Count (60 Day)	9
Device Activity Count (90 Day)	9
Device Activity Count (180 Day)	9
Device Activity Count (365 Day)	9
Device Run Count (7 Day)	0
Device Run Count (14 Day)	31
Device Run Count (30 Day)	41
Device Run Count (60 Day)	41
Device Run Count (90 Day)	41
Device Run Count (180 Day)	41
Device Run Count (365 Day)	41

This repeats for each user. 

I would like to split the table into four columns based on Device Activity Count / Device Run Count as such: 

Device Activity Count	Activity Value	Device Run Count	Run Value
Device Activity Count (7 Day)	0	Device Run Count (7 Day)	0
Device Activity Count (14 Day)	3	Device Run Count (14 Day)	31
Device Activity Count (30 Day)	9	Device Run Count (30 Day)	41
Device Activity Count (60 Day)	9	Device Run Count (60 Day)	41
Device Activity Count (90 Day)	9	Device Run Count (90 Day)	41
Device Activity Count (180 Day)	9	Device Run Count (180 Day)	41
Device Activity Count (365 Day)	9	Device Run Count (365 Day)	41

Any thoughts on how I could accomplish this? 

Appreciate any assistance! 

[echuong1 · Accepted solution]

You can filter on a key word such as "run." From there, you can join by position to get them next to each other.

[atjhsieh]

Seems like it worked, thanks so much!