Google Spreadsheet Post #2423
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Apr-13-2018
question by: Arthur Shurn
https://productforums.google.com/forum/#!msg/docs/3gL5zqBfwxE/6EadHDwpCgAJ;context-place=forum/docs
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.
https://docs.google.com/ spreadsheets/d/1FWdsEkHc__Y_ OtmkVTs3X6GZtX7_ RAUDJH3aYYfu3K4/edit?usp= sharing
No comments:
Post a Comment