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: CR-V
Honda: Pilot
NISSAN: Altima
NISSAN: Maxima

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)