Grouping in MS Excel

Occasional Visitor

Hi,
I need to create a data in MS Excel of branches which come under a region in the following way:

Suppose I have A to Z branches in a region & I have to display figures of different parameters, say a to d, of these branches as:


(supposing there are rows and columns in this body text)

 

A a figure1 figure2 figure3
A b figure1 figure2 figure3
A c figure1 figure2 figure3
A d figure1 figure2 figure3
B a figure1 figure2 figure3
B b figure1 figure2 figure3
B c figure1 figure2 figure3
B d figure1 figure2 figure3
C a figure1 figure2 figure3
C b figure1 figure2 figure3
C c figure1 figure2 figure3
C d figure1 figure2 figure3
.
.
.
Z a figure1 figure2 figure3
Z b figure1 figure2 figure3
Z c figure1 figure2 figure3
Z d figure1 figure2 figure3


How can I approach this in excel? All figures are to be fetched using vlookup function.

0 Replies