How can I take multiple rows of different data for one user, and move them into columns so that each user has only one row.
In my example, I have three tables. The table in red is the current data I have. The tables in green are what I want to convert the data to.
I tried moving each value into its own column with a formula placing a formula in a different column and moving the data over like this: In C2,
=IF B2=21, B2' then copying the data into one row and deleting the others. This is long and complicated process and I am wondering if there is a better way.
You may try: