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
<tbody>
</tbody>
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
<tbody>
</tbody>
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
IP Address | 192.168.1.1 |
MAC Address | 00:00:00:00:00:00 |
Vendor | Microsoft |
Host Name | server.domain.local |
State | Device is Up |
First Seen | 01 September 2014 |
NetBIOS Name | SERVER |
Domain Controller | Yes |
File Server | Yes |
IP Address | 192.168.1.2 |
MAC Address | 00:00:00:00:00:00 |
Vendor | Microsoft |
Host Name | server.domain.local |
State | Device is Up |
First Seen | 01 September 2014 |
NetBIOS Name | SERVER |
Domain Controller | Yes |
File Server | Yes |
<tbody>
</tbody>
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
IP Address | MAC Address | Vendor | Host Name | NetBIOS Name | Domain Controller | File Server |
192.168.1.1 | 00:00:00:00:00 | Microsoft | server.local | SERVER | YES | Yes |
192.168.1.2 | 00:00:00:00:00 | Microsoft | server.local | SERVER | YES | Yes |
<tbody>
</tbody>
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!