JP2R
05-13-2008, 06:46 PM
Greetings!
I'm using:
Microsoft XP
Microsoft Office 2007
I have a table with four columns of data.
It looks something like this:
Col1 Col2 Col3 Col4
VLan 123 name MACaddress
VLan 240 name MACaddress
VLan 140 name MACaddress
Using =concatenate() I have combined Column 1 and 2 and I have also combined Column 3 and 4, so that it looks this...
VLan 123 name MACaddress
Now what I'm trying to figure out is how to put it into a column so that it stacks like this:
VLan 123
name MACaddress
(skip row)
VLan 240
name MACaddress
and so on - please note that name and MACaddress are just place holders for actualy data - a persons name and the MACaddress to thier device.
Is there an easy way to do this - a function or VBA?
I would greatly appreciate any assistance offered.
Thanks so much
-- Jae :banghead:
VLan
I'm using:
Microsoft XP
Microsoft Office 2007
I have a table with four columns of data.
It looks something like this:
Col1 Col2 Col3 Col4
VLan 123 name MACaddress
VLan 240 name MACaddress
VLan 140 name MACaddress
Using =concatenate() I have combined Column 1 and 2 and I have also combined Column 3 and 4, so that it looks this...
VLan 123 name MACaddress
Now what I'm trying to figure out is how to put it into a column so that it stacks like this:
VLan 123
name MACaddress
(skip row)
VLan 240
name MACaddress
and so on - please note that name and MACaddress are just place holders for actualy data - a persons name and the MACaddress to thier device.
Is there an easy way to do this - a function or VBA?
I would greatly appreciate any assistance offered.
Thanks so much
-- Jae :banghead:
VLan