Need to turn repeating row values into combined columns: see below!

Hi there! I'm new to posting here, but you all are so helpful, I'd like to share a problem. If you could spare a second to help me, that'd be so great-, I'm under a serious time crunch- Thank you!!

I have 1 column of pasted values that basically look like this
c
1:a
2:b
3:c
1:d
2:e
3:f etc...

And they need to look like this:
c1 c2 c3
a b c
d e f

I know how to separate the first column into two columns by separating the values by the colon. But how do I rearrange the values as above and combine all "1"s in c1 so it becomes the headers and the column is populated only with the values? The table is too big to do manually (thousands of rows).

Thank you so much for any help you can provide!!!!

Hi and welcome to the forum!

It's not quite clear from your pasted example what you require. Could you upload a workbook with a (preferably slightly larger) example and your desired result clearly outlined?

Regards