I need to change the view of data in my spreadsheet, but can't figure a solution of how to get from point a to b.
You will see in attached point A how the data is currently. Column A has one row for each record giving the member ID. Instead of several rows per member ID with the member ID duplicated on each row. I need one row per member ID as in attached Point B. You can see that the one row per member ID has the data regrouped horizontally with 3 columns per record etc. How can I make this transition?