Convert Table of Values into List

[cplib]

Hi All

First Post, am trying to make sure I follow forum ettiquette and I have tried searching for an answer to this question! Its probably that I am not searching the correct terms, so please forgive me if this has been answered already.

Attached is an example of what I would like to achieve. It's sort of the opposite of a summary i.e. I have a table that shows

A 2
B 4
C 6

And what I would like to see iss

A
A
B
B
B
B
C
C
C
C
C
C

This is just an example in reality I have to deal with 90+rows and possibly 100's of each of them.

Thanks in advance

Chris

[JieJenn]

not good with formula, but in VBA, it can be done easily.

Please Login or Register  to view this content.

[cplib]

Thanks, almost there I need to show A rather than 1, I think all I need to do is change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[JieJenn]

oops. yeah, you got it right. Just change the value to .cells(i,1).value