With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, April 13, 2018
yogi_Consolidate Names Of Registrants From Several Columns Into A Single Column
How to Consoliadte Multiple Columns into a Single Column
I have a spreed sheet that is a collection of registration information. Each person who registers is allowed to register more than just himself/ herself. Thus I have several columns with names within each registration. I need to create a master registration which is a single column of all the names registered. Is there a way to do this with Pivot tables. I’m familiar with pivot tables but have not been able to extract this master registration list without cut and pasting the information. I have included a sample of my sheet.