Sunday, April 14, 2013

yogi_In A Table of Multiple IDs And Dates Pull Unique IDs And Transpose The Corresponding Dates For Each ID

                                          Google Spreadsheet   Post  #1125
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 14, 2013
user StudentSupport  :(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/IS2IjYNEwl8)
transpose list (id's)

Working with a list of id's. If an id comes up more than once I want to transpose. I have 2 separate formulas 1) finds the ids and puts them in a list and 2) finds the dates and kind of transposes them.

I want to combine these to make 1 array (?) formula that can do both. I filled both formulas with colors on the test sheet.

------------------------------------------------------------------------------------------------------------------------