Convert Table of Values into List

**cplib** · 12-05-2012, 01:23 PM

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** · 12-05-2012, 01:38 PM

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

Dim ws As Worksheet: Set ws = ThisWorkbook.Worksheets("Input")
Dim i As Long, LR As Long, lFill As Long

With ws
.Columns("F").ClearContents
LR = .Cells(Rows.Count, 1).End(xlUp).Row
    For i = 1 To LR
    lFill = .Cells(Rows.Count, 6).End(xlUp).Row + 1
        .Cells(lFill, 6).Value = .Cells(i, 2).Value
        .Cells(lFill, 6).AutoFill .Range(.Cells(lFill, 6), .Cells(lFill + .Cells(i, 2).Value - 1, 6))
    Next i
End With

**cplib** · 12-05-2012, 01:46 PM

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

.Cells(lFill, 6).Value = .Cells(i, 2).Value

to

.Cells(lFill, 6).Value = .Cells(i, 1).Value

**JieJenn** · 12-05-2012, 01:47 PM

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

Convert Table of Values into List

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Convert Table of Values into List

Re: Convert Table of Values into List

Re: Convert Table of Values into List

Re: Convert Table of Values into List

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions