73345923459
New Member
- Joined
- Sep 5, 2014
- Messages
- 4
Hi All
I have some data in Excel 2010 that I would like to rearrange but I am struggling to figure out how to do this. The data looks like this
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 123, bgcolor: transparent"]IP Address[/TD]
[TD="width: 197, bgcolor: transparent"]192.168.1.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]MAC Address[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00:00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Vendor[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Host Name[/TD]
[TD="bgcolor: transparent"]server.domain.local[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]State[/TD]
[TD="bgcolor: transparent"]Device is Up[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]First Seen[/TD]
[TD="bgcolor: transparent"]01 September 2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]NetBIOS Name[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Domain Controller[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]File Server[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]IP Address[/TD]
[TD="bgcolor: transparent"]192.168.1.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]MAC Address[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00:00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Vendor[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Host Name[/TD]
[TD="bgcolor: transparent"]server.domain.local[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]State[/TD]
[TD="bgcolor: transparent"]Device is Up[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]First Seen[/TD]
[TD="bgcolor: transparent"]01 September 2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]NetBIOS Name[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Domain Controller[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]File Server[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
</tbody>[/TABLE]
and it continues on but not every section has all the same as above but they all have IP Address, MAC Address and Vendor.
What I am trying to do is change it so that I have
[TABLE="width: 585"]
<tbody>[TR]
[TD="width: 99, bgcolor: transparent"]IP Address[/TD]
[TD="width: 123, bgcolor: transparent"]MAC Address[/TD]
[TD="width: 86, bgcolor: transparent"]Vendor[/TD]
[TD="width: 124, bgcolor: transparent"]Host Name[/TD]
[TD="width: 115, bgcolor: transparent"]NetBIOS Name[/TD]
[TD="width: 140, bgcolor: transparent"]Domain Controller[/TD]
[TD="width: 93, bgcolor: transparent"]File Server[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]192.168.1.1[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[TD="bgcolor: transparent"]server.local[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[TD="bgcolor: transparent"]YES[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]192.168.1.2[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[TD="bgcolor: transparent"]server.local[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[TD="bgcolor: transparent"]YES[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
</tbody>[/TABLE]
I have tried a number of formulas but I am stuck and need a fresh pair of eyes to help me in the right direction. Is there a formula or a number of formulas that can help me populate the data into multiple columns?
Many thanks for your help in advance!
I have some data in Excel 2010 that I would like to rearrange but I am struggling to figure out how to do this. The data looks like this
[TABLE="width: 240"]
<tbody>[TR]
[TD="width: 123, bgcolor: transparent"]IP Address[/TD]
[TD="width: 197, bgcolor: transparent"]192.168.1.1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]MAC Address[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00:00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Vendor[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Host Name[/TD]
[TD="bgcolor: transparent"]server.domain.local[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]State[/TD]
[TD="bgcolor: transparent"]Device is Up[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]First Seen[/TD]
[TD="bgcolor: transparent"]01 September 2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]NetBIOS Name[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Domain Controller[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]File Server[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]IP Address[/TD]
[TD="bgcolor: transparent"]192.168.1.2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]MAC Address[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00:00[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Vendor[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Host Name[/TD]
[TD="bgcolor: transparent"]server.domain.local[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]State[/TD]
[TD="bgcolor: transparent"]Device is Up[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]First Seen[/TD]
[TD="bgcolor: transparent"]01 September 2014[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]NetBIOS Name[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Domain Controller[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]File Server[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
</tbody>[/TABLE]
and it continues on but not every section has all the same as above but they all have IP Address, MAC Address and Vendor.
What I am trying to do is change it so that I have
[TABLE="width: 585"]
<tbody>[TR]
[TD="width: 99, bgcolor: transparent"]IP Address[/TD]
[TD="width: 123, bgcolor: transparent"]MAC Address[/TD]
[TD="width: 86, bgcolor: transparent"]Vendor[/TD]
[TD="width: 124, bgcolor: transparent"]Host Name[/TD]
[TD="width: 115, bgcolor: transparent"]NetBIOS Name[/TD]
[TD="width: 140, bgcolor: transparent"]Domain Controller[/TD]
[TD="width: 93, bgcolor: transparent"]File Server[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]192.168.1.1[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[TD="bgcolor: transparent"]server.local[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[TD="bgcolor: transparent"]YES[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]192.168.1.2[/TD]
[TD="bgcolor: transparent"]00:00:00:00:00[/TD]
[TD="bgcolor: transparent"]Microsoft[/TD]
[TD="bgcolor: transparent"]server.local[/TD]
[TD="bgcolor: transparent"]SERVER[/TD]
[TD="bgcolor: transparent"]YES[/TD]
[TD="bgcolor: transparent"]Yes[/TD]
[/TR]
</tbody>[/TABLE]
I have tried a number of formulas but I am stuck and need a fresh pair of eyes to help me in the right direction. Is there a formula or a number of formulas that can help me populate the data into multiple columns?
Many thanks for your help in advance!