Need small Help

[mu4you]

I have large data in excel sheet and the data as follows:

A1 - Supplier Name
A2 - Item Codes

in same way I have many supplieres and have many items in each supplier.

What I want is:
in Cell A1 Supplier Name in B1 Items Code.

Example.
this is Actual Data:
A1 - Rolaco
A2 - XXY
A3 - XXZ
A4 - ZZZ

I am looking for out put as follows:

A1. Rolaco B1. XXY
A2. Rolaco B2. XXZ
A3. Rolaco B3. ZZZ

Thanks in advance.

 

[jimrward]

how can you tell between a supplier and an item code, as in your example they both contain letters, so I cannot tell by looking at the list where to start the next group

can you past a few lines of proper data

 

[mu4you]

A1 Rolaco is Supplier Name
A2. Item codes.

 

[Ganjin]

is the item code always 3 characters?

 

[jimrward]

are the item codes 3 letters or numeric
if I see data in a list how do I know what are item codes, i have no idea