Turn 2 short columns into 1 longer col

Please help and thanks

Original table |Group1|Group2|Population1|Pop2| |--|--|--|--| |"USA"| "ENG"| 1000| 502| |"RUS"| "FRC"| 1200| 200|

Expected table |Nation|Population| |--|--| |"USA"|1000| |"RUS"|1200| | "ENG"|502| | "FRC"|200|

Read more here: https://stackoverflow.com/questions/66272319/turn-2-short-columns-into-1-longer-col

Content Attribution

This content was originally published by Will N at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: