Wednesday, December 14, 2011

yogi_Convert Rows Of Many-to-One Data Into Rows Of One-to-One Data

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user mtm4319 said:
How do I un-bunch several rows of many-to-one data into rows of one-to-one data?
Here is a spreadsheet illustrating my problem: want the data from columns A and B to turn into the data in columns G and H using formulas.I'm already two steps of the way there, by joining the rows of data in column A, then splitting and transposing it using the ", " delimiters. But the issue is column B. Does anyone know how I could get there?
following is a solution to a more generalized problem ... wherein I have used duplicate names with different attributes