Sorting/Combining Text Strings and Numbers

[mjstebbs]

Hello,

I am trying to consolidate the data below into the table following. I have tried using If, Vlookup, and other functions, but I seem to get stuck every time. The goal is to combine the first column into a list of numbers with the same columns following. Any help is greatly appreciated. If I can provide any other info let me know. Thanks

[TABLE="class: grid, width: 256"]
<tbody>[TR]
[TD="width: 64"]*[/TD]
[TD="width: 64"]*[/TD]
[TD="width: 64"]*[/TD]
[TD="width: 64"]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD="align: right"]10.2929[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]7.719677[/TD]
[TD="align: right"]7.542407[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]7.719677[/TD]
[TD="align: right"]7.542407[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD="align: right"]23[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]26[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]32[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD="align: right"]37[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]10.2929[/TD]
[TD="align: right"]10.41933[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="class: grid, width: 333"]
<tbody>[TR]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]4 5 6 7 31 32 33[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9 10 35 37 40[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]20.46506[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]10.05654[/TD]
[TD="align: right"]10.2929[/TD]
[/TR]
[TR]
[TD]15 19[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]7.719677[/TD]
[TD="align: right"]7.542407[/TD]
[/TR]
[TR]
[TD]16 17 20 23 24 25 26 38[/TD]
[TD]UNI GX[/TD]
[TD="align: right"]7.542407[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD]TRAP GX[/TD]
[TD="align: right"]10.2929[/TD]
[TD="align: right"]10.41933[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1064366-sorting-combining-text-strings-numbers.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.