I have a set of data in this format:
a x 12
b x 14
c x 18
a y etc.
b y
c y
a z
b z
c z
And i want it in this table format:
x y z
a # # #
b # # #
c # # #
What is the relevant formulae? I've tried some mashups of offset, index and match to no avail.
An example spreadsheet is attached if you want to have a go.
Cheers,
TF
Bookmarks