antlan1969
New Member
- Joined
- Mar 1, 2016
- Messages
- 1
Hi,
I hope I can describe this properly. I have imported a load of CSVs into 1 big file but the 3 headings I want to use are all rows at the moment.
I am a bit of an Excel newbie when it comes to manipulating data. I need help trying to convert the data from something like this...
<colgroup><col><col></colgroup><tbody>
</tbody>
To look like this.....
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am figuring if I can get the data I have into this format it will be easier to analyse.
Any help would be appreciated!
Cheers,
Anthony
I hope I can describe this properly. I have imported a load of CSVs into 1 big file but the 3 headings I want to use are all rows at the moment.
I am a bit of an Excel newbie when it comes to manipulating data. I need help trying to convert the data from something like this...
Username | user1 |
Drive | P |
UNCPath | \\server1\share1 |
Drive | T |
UNCPath | \\server2\share2 |
Drive | Z |
UNCPath | \\server3\share1 |
Username | user2 |
Drive | P |
UNCPath | \\server1\share1 |
Drive | T |
UNCPath | \\server2\share2 |
Username | user3 |
<colgroup><col><col></colgroup><tbody>
</tbody>
To look like this.....
Username | Drive | UNCPath |
user1 | P | \\server1\share1 |
user1 | T | \\server2\share2 |
user1 | Z | \\server3\share1 |
user2 | P | \\server1\share1 |
user2 | T | \\server2\share2 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am figuring if I can get the data I have into this format it will be easier to analyse.
Any help would be appreciated!
Cheers,
Anthony