Stacking Data in Google Sheets
Have you ever been working with a spreadsheet that had a bunch of values separated by commas, semicolons, pipes, or new lines in a single column? Something like this?
Recipient | Goods |
---|---|
Michaelangelo | Pizza, nunchucks, skateboard |
Donatello | DisplayPort cables, Redbull |
Leonardo | Kale, Seitan, courage |
Raphael | knives, punching bag, beef, roller skates … |