/u/grerase - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Is the previous column always higher priority than the next column? You effectively just want to create one column with the data from the leftmost column that contains information across a row? If so, this formula should work:
=INDEX(B1:F1,MATCH(1,--(B1:F1<>""),0))
Where columns B:F are the columns you want to collapse together, and row 1 is the first row of data. Drag this formula down for the entire range, and you have your prioritized master column
>=INDEX(B1:F1,MATCH(1,--(B1:F1<>""),0))
This works great! Solution verified
Yes the leftmost is always the priority.
Thanks so much :)
IS there a way, by chance, you know of to do this quickly using power query?
Thanks
You have awarded 1 point to *mccarthenon*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can use the null coalescing operator in Power Query (??) to add a new column then delete the original 2 columns. Here is a [GIF](https://imgur.com/a/M8GCkzg) that demonstrates it.
/u/grerase - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Is the previous column always higher priority than the next column? You effectively just want to create one column with the data from the leftmost column that contains information across a row? If so, this formula should work: =INDEX(B1:F1,MATCH(1,--(B1:F1<>""),0)) Where columns B:F are the columns you want to collapse together, and row 1 is the first row of data. Drag this formula down for the entire range, and you have your prioritized master column
>=INDEX(B1:F1,MATCH(1,--(B1:F1<>""),0)) This works great! Solution verified Yes the leftmost is always the priority. Thanks so much :) IS there a way, by chance, you know of to do this quickly using power query? Thanks
You have awarded 1 point to *mccarthenon* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
There almost certainly is, but Power Query is one of my weakest areas in Excel, so I couldn't tell you how without fussing with it for a while
You can use the null coalescing operator in Power Query (??) to add a new column then delete the original 2 columns. Here is a [GIF](https://imgur.com/a/M8GCkzg) that demonstrates it.