Lists to Columns

I have a long list of data that I would like to separate into different columns.

Attached is my example file
lists to columns.xlsx

hope you can help

I am happy to use either formula or vb code

regards

kevin

Put this formula in cell C2:

=IF(A2="","",A2&"_"&COUNTIF(A$2:A2,A2))

and copy down to the bottom of your data.

Then put this formula in E2:

=IFERROR(INDEX($B:$B,MATCH(E$1&"_"&ROWS($1:1),$C:$C,0)),"")

copy across to G2, then copy E2:G2 down as far as you need them (until you get blanks in all cells on a row).

Hope this helps.

Pete

Sorry Pete
I could not get this to work

Can I just check that I'd like the company titles as column titles.

Kev

Look at my attached file, to see where you went wrong (perhaps you omitted some of the $ signs).

Hope this helps.

Pete

ah got it.

this is excellent it works

thank you for your time

kevin