Trying to find a less manual way of sorting data and not sure if there's a formula that I could run to accomplish this or if it needs to be a query.
Please see image for reference. It's a bit complicated.
Basically, I am identifying duplicate rows in my spreadsheet by the email column F. I need to pull the second identified duplicate row's data into the columns to the right of each intermittently filled column, based off the duplicate email. So row 2 data stays as is in that row, but the data in row 3 (being a duplicate email in column F) is moved up to row 2, in the empty columns following the order they're in (H, J, L). What is the best way to accomplish this?
Please see image for reference. It's a bit complicated.
Basically, I am identifying duplicate rows in my spreadsheet by the email column F. I need to pull the second identified duplicate row's data into the columns to the right of each intermittently filled column, based off the duplicate email. So row 2 data stays as is in that row, but the data in row 3 (being a duplicate email in column F) is moved up to row 2, in the empty columns following the order they're in (H, J, L). What is the best way to accomplish this?
