'How to create table where each cell in column A is next to each cell in column B
Good day, I'm not sure how to phrase the question I'm trying to ask so I'll try with an example.
I have 2 columns with a lot of data:
What I'm trying and failing to do is to "mix" the information but not the cells. Similar to concatenate but not merging them into one cell, instead I want them in the same number of columns. Is there a name to this process?
So that the final result would look similar to this:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|