Excel - Formula to consolidate columns
Budget: $10 – $30 USD
The items in the attached spreadsheet each have a value assigned for an Image Path and Angle. There are four different sets of these. Only one set from each type can be assigned to a row.
We need to consolidate this data into 3 columns.
Column M - This should get the NAME OF THE COLUMN that contains a value for that row ("MAXImage", "MXRightImage", "MXLeftImage", "MANImage")
Column N - This should be the value residing in any of the above-populated xxxImage columns
Column O - This should be the value residing in the xxxANG column
The attached image example shows the first three rows with properly consolidated data.
I have also attached the spreadsheet to reference.
We need to consolidate this data into 3 columns.
Column M - This should get the NAME OF THE COLUMN that contains a value for that row ("MAXImage", "MXRightImage", "MXLeftImage", "MANImage")
Column N - This should be the value residing in any of the above-populated xxxImage columns
Column O - This should be the value residing in the xxxANG column
The attached image example shows the first three rows with properly consolidated data.
I have also attached the spreadsheet to reference.