ANmarS - Portfolio - 2Cols2ColRow

Excel/VBA expert since Sep 1997 (20 years 11 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

2Cols2ColRow    Added: 8/20/2011 | Created: 4/15/2009   



Convert 2 columns table into Col-Row table using formulas only, no macros

In another word, convert:
Honda: ACCORD
Honda: CR-V
Honda: Pilot
NISSAN: Altima
NISSAN: Maxima

Into:
Honda - NISSAN
ACCORD - Altima
CR-V - Maxima
Pilot -

Very helpful if you have a long list and don't want to copy/paste


Download (5.3 KB)

1163 downloads | Last updated: 1/15/2014


Screen shots (6)