How to convert data from multiple columns to one column Converting data from multiple columns to one column is a common requirement and we struggle to get this done. Very often we would have to resort to manual cut and paste. Read »