Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or ...

Where <prefix> is the prefix to be added and <cell number of first cell> is the location of the first cell in the column to which to add the prefix. Eg. We are creating the list in column C.