yogi_Rearrange Table In A2:B5 In A DataBase Style Table

Google Spreadsheet   Post  #2147

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-08-2017

question by Edward Hugh Summers:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/oS2TqOa6OUA;context-place=mydiscussions

Transpose Question

---

Hi Yogi and Ballow. Here's an example of the type of transformation I want to do in a sheet:

https://docs.google.com/spreadsheets/d/1ZbsE-B_VQBKHdbhJTLSDn8o8jPOXRQHFC9RtF9y4cFI/edit?usp=sharing

Conceptually I don't think it's that complicated. It is worth noting that I'm not really interested in a solution that involves lots of repetition for each row, because there could be an arbitrary number of rows. I can do this fine outside of Google Sheets (in Python) but I was wondering if it's possible without leaving sheets for the classroom setting. If not, no need to stress :-)

If you are interested I want to turn the rows of data into an edge list that I can then visualize as a graph in Google Fusion Tables. 

yogi_Transpose ITEMS In A Table To A Single Column List

Google Spreadsheet   Post  #2146

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-06-2017

question by Edward Hugh Summers:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/oS2TqOa6OUA;context-place=mydiscussions

Transpose Question

 

I have a table like this:

  A 1 2 3

  B 3 2 1

Is it possible to use Sheets to transpose it into:

  A 1

  A 2

  A 3 

  B 3

  B 2

  B 1

Any help you can provide would be greatly appreciated!