Yes, you could use an array

Dim myArray(1 to 3, 1 to ##)

you can then reference it like so:

myArray(1,1) = "UserID 1"
myArray(2,1) = "Task ID 1"
myArray(3,1) = "Priority 1"
myArray(1,2) = "UserID 2"
myArray(2,2) = "Task ID 2"
myArray(3,2) = "Priority 2"

etc


Russell wrote:
I'm sure this is rather simple, however, I'm new to programming and VBA.

I have a spreadsheet where the first column contains the User IDs and the
first row contains the Task IDs. All of the other cells in between contain a
'1' or '2' (priority) where the user has the task. There are many blank cells.

I would like to take this data and put it into 3 columns -- User ID, Task
ID, and Priority. I'm guessing this can be done with an array in VBA, but
that is quite new to me.

Thanks in advance.